Converting formatted numbers to formatted text in a string

[dfein]

We have a formula that uses cells and converts them to text. For example a cell may have the formulas ="text of cell A1 is " & A1", this works but the string that is converted for cell A1 has no format. We can use the Text(a1,"$###,###,###.00") in the string, but this hard codes the format into the formula.

Is there a way to have the cell show up as a string with the same format as the cell without having to specify the format manually/statically?

I don't want to use VBA I would like a formula based solution.l

Thanks,

David

 

[SIXTH SENSE]

hi!
have you tried formating the cell itself? rigth click on the cell then froamat cell, then custom fromat.