Concatenate and preserve number format

[adrienne0914]

Cell A1 contains $26,501,370.27. I have a custom format so that it appears as $26.501 million. Trying to figure out how to preserve this format in CONCATENATE as text. I tried TEXT(A1,$#.000,," million") but get a formula error message.

 

[adrienne0914]

Personally I would just change to the version Peter proposed in cell C1, there are no downsides to using it

I will do that now. Thanks, both.

 

[Peter_SSs]

I will do that now. Thanks, both.

You are welcome. I think that is a safer option (& you will still have it for the future).