ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How Show decimal in Bar Function (https://www.excelbanter.com/excel-worksheet-functions/44659-how-show-decimal-bar-function.html)

Babba

How Show decimal in Bar Function
 
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?

Thanks!!!!

Babba

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

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



"Babba" 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?

Thanks!!!!



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com