appended a cell, but need to keep decimal places

[juliekim04]

hi,
in cell a1, i have 720.00 and i need to make it "720.00" (basically
adding quotes around it).

i'm using the following formula
=""""&a1&""""

and i'm getting "720" which is almost there, but i need the two
decimals.

if in cell b1 i have 720.25 and i use the formula above, i get
"720.25" which is great...

any thoughts on me losing the trailing zeros in the first example?

thank you for your help!!

 

[Gord Dibben]

=""""&TEXT(A1,"#,##0.00")&""""


Gord Dibben MS Excel MVP

 

[David Biddulph]

=""""&TEXT(a1,"0.00")&""""