Excel Formatting
Excel Formatting
(OP)
Excel97 SR-2.
Cell C47 contains the following ="Text"&E45&"% Text" where E45 has an equation formatted to display a Number with 1 decimal place. How do I get my text cell to use the same formatting. Right now I get umpteen decimals.
Thanks,
Roger
Cell C47 contains the following ="Text"&E45&"% Text" where E45 has an equation formatted to display a Number with 1 decimal place. How do I get my text cell to use the same formatting. Right now I get umpteen decimals.
Thanks,
Roger





RE: Excel Formatting
="Text"&Round(E45;Number_of_digits)&"% Text"
; may be , depending on your regional settings
hope this helps
regards
Mogens
RE: Excel Formatting
="Text"&INT(E45*10)/10&"% Text"
note
="Text"&(INT(E45*10)+5)/10&"% Text"
should round of the digit as well.
Hope this helps
Thanks
RE: Excel Formatting
Thanks
RE: Excel Formatting
RE: Excel Formatting
="Text"&Fixed(E45,1)&"% Text"
Don Coffman
RE: Excel Formatting
="Text "&TEXT(Q19,"0.00")&" Text"
Replace the "0.00" with any formatting code you like (see Custom Number Formats in the XL help)
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.