number entered in cell loses trailing zeros in formula bar

[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

 

[David Biddulph]

Format as text *before* you enter the data, or precede the data with an
apostrophe.

 

[Pete_UK]

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

 

[GKeyedr]

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

 

[David Biddulph]

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.

 

[GKeyedr]

That did the trick! Thank you all so much!
Gene

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.