Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 151
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,276
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Round down if decimal 0.33 or below up if 0.34 or above tennisnut Excel Discussion (Misc queries) 3 April 23rd 09 11:57 AM
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 tiffa Excel Worksheet Functions 4 May 5th 08 02:00 PM
Round a repeating decimal from a formula... Snake2135 Excel Worksheet Functions 14 February 23rd 08 05:04 PM
Round a negative decimal Montana Excel Worksheet Functions 8 November 20th 07 07:09 AM
ROUND DATA TO 2 DECIMAL PLACES roy in sunbury New Users to Excel 1 January 12th 05 04:33 AM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"