Convert Number to Text, Masters?

[a-frustrated-excel-user]

I want to convert number 5.00 to text, but keep .00, two decimals into text.

I tried format cell, but .00 is gone, it game me 5. I want 5.00.

Masters out there?

 

[John Bundy]

See if this does what you want:

=TEXT(A1,".00")

 

[T. Valko]

Try this:

=TEXT(5,"0.00")

Or:

=TEXT(A1,"0.00")

Biff

 

[a-frustrated-excel-user]

thank you, MVPs (Master, Very Pure)