Concatenate & Number Formats
 

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.

Concatenate & Number Formats
 

To retain the format of A2:

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"messy19" wrote in message ...
| 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.

Concatenate & Number Formats
 

Thank you!

"Niek Otten" wrote:

To retain the format of A2:

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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"messy19" wrote in message ...
| 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.