Cell = Formula Bar

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

Guest

I have a worksheet where the actual number shows 123.456789 in the formula bar, but displays as 123.46 in the cell. I want the actual number in the formula bar to be 123.46. I really don't want to use a formula because in the past it has affected my merge documents. Any suggestions?
 
One way is to use Tools / Options / Calculation / Precision as displayed

Note though, that this setting is global and will affect all sheets, and once
the data has been truncated it is gone

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



PICWI said:
I have a worksheet where the actual number shows 123.456789 in the formula
Click to expand...
bar, but displays as 123.46 in the cell. I want the actual number in the
formula bar to be 123.46. I really don't want to use a formula because in the
past it has affected my merge documents. Any suggestions?
 

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

Cell shows the last typed text, no matter where it is typed 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Currency Symbols in custom formats when imported from HTML? 1
Formula Bar contents missing 8
Leading Zero 11
Formula Bar - display of content 4
Displaying results in formula bar when cell is hidden 1
Zeros in Formula Bar 3

Back
Top