View Single Post
  #1   Report Post  
Babba M via OfficeKB.com
 
Posts: n/a
Default 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!!!!