Showing 0 after decimal with ROUND

  • Thread starter Thread starter Libby
  • Start date Start date
L

Libby

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
 
Format the cell as Number with 1 decimal place - it would appear to be
formatted as General.

Hope this helps.

Pete
 
Slap a text around it and play until you like it. This achieves what i
believe you want:
=TEXT(ROUND(C29*(92%),1),"##.0") & TEXT(-ROUND(C29*(108%),1),"##.0")
 
He's using text concatenation, so the format in the cell won't help, Pete.

=TEXT(ROUND(C29*92%,1),"0.0") & TEXT(- ROUND(C29*108%,1),"0.0")
or perhaps
=TEXT(ROUND(C29*92%,1),"0.0") &"-"& TEXT(ROUND(C29*108%,1),"0.0")
depending on how you want to treat zeroes and negative numbers.
--
David Biddulph


Format the cell as Number with 1 decimal place - it would appear to be
formatted as General.

Hope this helps.

Pete
 
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
 
Brilliant, John Bundy! Thanks a lot :)

John Bundy said:
Slap a text around it and play until you like it. This achieves what i
believe you want:
=TEXT(ROUND(C29*(92%),1),"##.0") & TEXT(-ROUND(C29*(108%),1),"##.0")
 
Back
Top