Convert Number to Text, Masters?
See if this does what you want:
=TEXT(A1,".00")
"a-frustrated-excel-user"
wrote in message ...
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?
|