Formatting in the formula bar

B

Beccy

When i type in a number into a cell in my worksheet, say:

42.99

Excel automatically rounds it to 43. Which is what i want and what i set it
up to do.
However, the number in the formula bar also rounds to 43.
Normally i thought the formula bar stayed at 42.99 and only the spreadsheet
cell rounds to 43.

I am using Excel 2000.

Please help asap as i need the formula bar to stay at 42.99 so i remember
what the original number was!!!
 
F

Frank Kabel

Hi
maybe you have checked 'Tools - Options - Calculation - Precision as
displayed'
 
Top