Prev: Can I use AVERAGEIFS?
Next: Remove blank cells from data validation drop down box
From: Libby on 4 Dec 2009 08:44
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
From: Pete_UK on 4 Dec 2009 08:59
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 <Li...(a)discussions.microsoft.com> 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

From: Eduardo on 4 Dec 2009 09:17
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
From: "David Biddulph" groups [at] on 4 Dec 2009 09:16
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" <pashurst(a)auditel.net> wrote in message
news:7d36eb67-f1da-4065-be14-1ab1fc61b1bb(a)c3g2000yqd.googlegroups.com...
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 <Li...(a)discussions.microsoft.com> 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


From: "David Biddulph" groups [at] on 4 Dec 2009 13:41
That doesn't work with text strings, Eduardo.
--
David Biddulph

"Eduardo" <Eduardo(a)discussions.microsoft.com> wrote in message
news:97E418FF-B471-495B-8AF0-71DE9A2AEAD5(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: Can I use AVERAGEIFS?
Next: Remove blank cells from data validation drop down box