Hi H,

Tools | Options | Calculation | Check the 'Precision as displayed' option.

---
Regards,
Norman



"HSalim[MVP]" wrote in message
...
Hi All.

I remember using a feature some time ago that would let you paste a
formatted value
So a 5 decimal value that was displayed as two digits could be saved or
converted to a 2 digit decimal.

It could be that this feature was in QuattroPro or Lotus, but I certainly
remember using it.
I cant find it now when I neeed it.

Thanks to anyone who can provide a solution.

Regards
HS