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