View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 93
Default 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?