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

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"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
oups.com...
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