Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 zero as last decimal
Hi.
I need to print out different number of decimals depending of cell value. If the value is <= 0.30 it should print out 2 decimals. If the value is greater it should have 1 decimal. This works by if/round formula. But if the last decimal is zero excel ignores it. How can I make this work? I tried to write a custom setting for cells, but then I got 0.00 in my empty cells. Custom setting [0,3]#0,0;[<=0,3]#0,00 (I use Norwegian decimal point ie ,) excel then slaps on ;Standard at the end of the setting. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Point Vertical Alignment in Excel 2003 | New Users to Excel | |||
Decimal point will not hold 2 places in Excel 2003 | Excel Worksheet Functions | |||
Decimal Point Excel 2003 | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
Decimal places in Excel 2003 | Excel Worksheet Functions |