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

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

Norman
Thank you very much.
I guess it is time to write some VBA to heal the pain of disappointment that
it is not a Paste Special option.

Regards
HS

"Norman Jones" wrote in message
...
: 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
:
:
:
: