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.

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

"messy19" <(E-Mail Removed)> wrote in message news:7F5BE591-0659-4661-A2AB-(E-Mail Removed)...
| 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.

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; Format>Cells>Number tab, select Custom and copy what is in the Type box
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "messy19" <(E-Mail Removed)> wrote in message news:7F5BE591-0659-4661-A2AB-(E-Mail Removed)...
> | 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.
>
>
>