Formatting in the formula bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula Bar Time Display Format 2
Missing Formula Bar 2
#NAME? error in formula in 03 but runs okay in excel 07 4
How to set the formula (26 Nov)? 3
Configure Formula Bar 6
Cell shows the last typed text, no matter where it is typed 0
Round formula 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0

Back
Top