Preserve decimal 0 in function bar
 

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

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.


On Fri, 09 Sep 2005 14:56:49 GMT, "Babba M via OfficeKB.com"
wrote:

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