Cell referenced as text

[Mike]

have cell A1 formatted as a number with 12.34 in it. Want to have cell B1
reference A1, but be formatted as text so it can be used for other purposes.
How can this be done?

 

[Peo Sjoblom]

=TEXT(A1,"0.00")


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Mike]

sorry. stupid question. I figured it out. Thanks though.