Preserve decimal 0 in function bar

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

 

[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.