View Single Post
  #3   Report Post  
yhtak
 
Posts: n/a
Default

Worked a treat, thanks very much

"Norman Jones" wrote:

Hi Yhtak:

Try:

Tools | Options | Edit | Untick the 'Fixed Decimal' option.



---
Regards,
Norman



"yhtak" wrote in message
...
My cell format is "general" with no decimal places and comma separator
ticked... if I enter a number e.g. 54389, the last two digits are dropped
and
the number rounds up. If I type the comma e.g. 54,389 it displays
correctly.
On Friday I didn't have to type in the comma, now I do. Can anyone
explain
what I need to do to get it to go back to the original format?