Formatting in the formula bar
 

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!!!

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

--
Regards
Frank Kabel
Frankfurt, Germany

Beccy wrote:
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!!!

Thank you so much you are a star!!!!

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

Beccy wrote:
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!!!