Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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!!!! |
#2
![]() |
|||
|
|||
![]()
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
simplify function | Excel Worksheet Functions | |||
Custom Function | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions |