How can I concatenate a number and preserve the formatting?

[imothers]

I am trying to concatenate a number and preserve its formatting, but
the concatenate formuula insists on presenting the unformatted version
of the number. Is there a way to enforce the format? Formatting the
cell where the concatenate function runs doesn't work. I have tried a
bunch of searches for help on "concatenate format" and get nothing
useful...

thanks for any help

 

[Max]

Use the TEXT function

Eg: Formatting a number as a percentage to 2 dp:
="Your score is " & TEXT(A1,"0.00%")

Try Debra's page at:
http://www.contextures.com/xlCombine01.html
Scroll down to "Formatting Examples"