number entered in cell loses trailing zeros in formula bar

  • Thread starter Thread starter GKeyedr
  • Start date Start date
G

GKeyedr

I am trying to copy numbers with number formatting (Ex:123.00 or 44.50) to
cells with text formatting. When I do this, the trailing zeros are lost
(123.00 becomes 123, and44.50 becomes 44.5). I have tried TEXT formatting
commands and the "Text To Columns" Wizard to no avail.
Gene
 
You could use this formula in the cells where you want the text values
to appear:

=TEXT(A1,"0.00")

then copy down as required.

Hope this helps.

Pete
 
Thanks for your reply, David. I guess I need to explain further. I have one
worksheet where the numbers I referred to are created by a formula. I need
to copy these numbers into another worksheet where all the cells are already
formatted as text.
Gene
 
That did the trick! Thank you all so much!
Gene

David Biddulph said:
If you have created the text copy of numbers in your required format by a
formula like =TEXT(A1-B2,"#.00"), you can copy and paste special values into
the other sheet, and it won't lose the trailing zeroes.
Click to expand...
 
Back
Top