Preserve decimal 0 in function bar

  • Thread starter Babba M via OfficeKB.com
  • Start date
B

Babba M via OfficeKB.com

Hi, my problem is to show decimal in bar function when decimal is 0

If i write "=3,00+2,70" excel write "=3+2,7".

How can i say excel to don't truncate 0?

A workaround is to write function like this:
="3,00"+"2,70"

....but i don't like it. There is another solutions?


Thanks!!!!
 
M

Myrna Larson

If you mean you want to change what you see in the cell, you do that with
formatting. Set the number of decimal places to 2. If you mean you want to
change what is displayed in the formula bar, I don't think that is possible.
 
Top