Concatenate & Number Formats

[messy19]

Can I maintain the number format from a cell I have in the string?
I am including a formula cell and the result comes up with several decimal
places and no dollar sign. I would like the resulting statement to have a
dollar value in it, not a long general format number with several decimal
places.

 

[Niek Otten]

To retain the format of A2:

=A1&TEXT(A2,"$#,##0.00")&A3

To get the right format string for A2; Format>Cells>Number tab, select Custom and copy what is in the Type box

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Can I maintain the number format from a cell I have in the string?
| I am including a formula cell and the result comes up with several decimal
| places and no dollar sign. I would like the resulting statement to have a
| dollar value in it, not a long general format number with several decimal
| places.

 

[messy19]

Thank you!