Showing 0 after decimal with ROUND
 

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

Answer: Showing 0 after decimal with ROUND
 

Hi Libby,

To force a 0 to display after the decimal, you can use the TEXT function to format the result of the ROUND function. Here's an example:

1. =TEXT(ROUND(C29*(92%),1),"0.0") & "-" & TEXT(ROUND(C29*(108%),1),"0.0")

In this formula, the "0.0" format code tells Excel to display one digit after the decimal, and to display a 0 if there is no digit to display. The "&" symbol is used to concatenate the two results with a hyphen in between.

If you have any macro or Visual Basic code, wrap it in the tags.

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

Showing 0 after decimal with ROUND
 

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


"Pete_UK" wrote in message
...
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

Showing 0 after decimal with ROUND
 

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

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