This is a great help to me. However I tried to modify it:

[<=-10]-0;[<10]0.00; [<100]0.0; 0

And Excel won't accept the number format. Did I do something wrong?


"David Biddulph" wrote:

You may want to think a bit further.
As -20 is less than 10, do you want that to show 2 decimals?
If what you intended was 2 decimals for numbers -10 and < 10, you may want
[<=-10]-0;[<10]0.00; 0
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Format Cell/ Number/ Custom
[<10]0.00; 0

You talked about <10 and 10, but I guessed that you meant =10.
--
David Biddulph

"Valeria" wrote in message
...
Dear experts,
I have a table which looks up values from a database; this table is
linked
to a cell where I can select what I want to see in the table.
Now, sometimes the values I want to see need to be in a 2 decimal format
(ex. 2.43) and sometimes they need to have no decimals at all (ex.
25000). It
really all depends on their magnitude - when <10 then I need to have 2
decimals, if 10 then no decimal is needed.
Is there a way to do this in Excel 2003?
Many thanks for your help!
Kind regards
--
Valeria