Excel Formatting

[rnordquest]

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

 

[mgp]

The only way I know of is to change formula to

="Text"&Round(E45;Number_of_digits)&"% Text"

; may be , depending on your regional settings

hope this helps

regards
Mogens

 

[FacilitiesCAD]

If you change the cell to this it will truncate the number to 1 pt
="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

 

[rnordquest]

What I was hoping was that I was doing something wrong so that I could control the formatting from the referenced cell. Since I can highlite and change the referenced cells all at once I was hoping there was a way to control it from there. Guess we have to do it the brute force way.

Thanks

 

[FacilitiesCAD]

You can always force the initial cell to be truncated but you then loose those extra digits that you dont see.

 

[psafety]

Roger,
="Text"&Fixed(E45,1)&"% Text"

Don Coffman

 

[joerd]

Just my five cents:
="Text "&TEXT(Q19,"0.00&quot&" 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.