excel 2003 zero as last decimal
It probably means that your value is not exactly zero. It could be, say,
0.00001 which displays as 0.00. Try rounding your result to 2 decimal places
(=round(yourformula,2)).
Regards,
Fred.
"Jarle" wrote in message
...
I'm still getting 0,00 in cells that shoul have been blank. In addition my
<
signs disappear. If there's anyway to put out a workbook it would be
easier
to explain. Mine is full of formulas, I know that macros and programming
could remove some. But I'm not familiar with programming yet.
Best regards
Jarle
"Luke M" wrote:
Just need to tell XL what do to with blanks.
[0,3]0,0;[<=0,3]0,00;;
Note that I created this using normal deicmals, and I am assuming you can
just replace the periods with commas.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Jarle" wrote:
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.
|