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


Gord Dibben MS Excel MVP

On 11 Apr 2007 14:12:12 -0700, wrote:

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!!