Showing 0 after decimal with ROUND

[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

 

[Pete_UK]

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

Hope this helps.

Pete

 

[John Bundy]

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")

 

[David Biddulph]

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

 

[Eduardo]

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]

Brilliant, John Bundy! Thanks a lot

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")

 

[David Biddulph]

That doesn't work with text strings, Eduardo.