Try this formula where 12.0 is in A1.
=ROUND(A1,2)
This will give 12 or 5.5 where A1 is 5.50.
Or replace A1 in the formula to be the formula you use to calculate the
values, to save having an extra cell and formula. Note that unlike cell
formatting which doesn't change the value but just shows it
differently, this formula can actually reduce the accuracy of the value
by rounding say 5.316454845 to 5.32. Therefore, don't use formulas that
in turn refer to the result of the round formula, unless you just want
it to use 5.32.
To give 100 decimal places (without trailing zeros), change it to
=round(a1,100).
If I haven't understood correctly, please explain further.
Clive


Robin Wrote:
I need calculated values to be displayed without any trailing zeros.
For
example:
if the result is 12.0, I need it displayed as 12
if the result is 5.50, I need it displayed as 5.5
but... in a worksheet of calculated values, I need the values displayed
to
the hundredth's place, as long as there are no trailing zeros, so I
can't
just format the cells to one placeholder.

Can this be done? THANX.


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=524964