Showing 0 after decimal with ROUND
That doesn't work with text strings, Eduardo.
--
David Biddulph
"Eduardo" wrote in message
...
Hi,
highlight the range, right click in the mouse, format cells, custom format
to show one decimal enter
0.0
to show 2 decimals
0.00
"Libby" wrote:
Hi,
I'm using the ROUND function like this:
=ROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
Unfortunately, if the numeral after the decimal is a 0, then it doesn't
display. How can I force a 0 to display after the decimal?
Libby
|