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