Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,118
Default Decrease Decimal in a combined text/formula cell

Try this:

="11 ("&TEXT(11/C2,"0.00%")&")"

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Zakhary" wrote:

Subject line says it all. I have a few cells where I have combined text with
a formula. The formula produces a decimal and I want to decrease the number
of decimal spaces therein. Using the basic buttons doesn't seem to work, nor
does going through the "format cell" system work. How do I decreae the
number of decimal places in a formula when the formula is combined with text.
Below is a formula to use as an example...

="11 ("&11/C2%&"%)"
displays... 11 (52.3809523809524%)

I want it to display... 11 (52.38%)

Thanks,
Zakhary

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
Cell References [email protected] Excel Discussion (Misc queries) 2 November 16th 06 12:37 AM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 06:12 PM
insert date Larry Excel Worksheet Functions 28 July 15th 06 03:41 AM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 09:31 PM
How many decimal places can a cell display? Spaz Excel Worksheet Functions 10 April 3rd 06 09:33 PM


All times are GMT +1. The time now is 06:06 AM.

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

About Us

"It's about Microsoft Excel"