Showing 0 after decimal with ROUND
Format the cell as Number with 1 decimal place - it would appear to be
formatted as General.
Hope this helps.
Pete
On Dec 4, 1:44*pm, 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
|