Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!! |
#2
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |