number entered in cell loses trailing zeros in formula bar
 

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

number entered in cell loses trailing zeros in formula bar
 

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

GKeyedr wrote:
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

number entered in cell loses trailing zeros in formula bar
 

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

On Jan 10, 4:43*pm, GKeyedr wrote:
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

number entered in cell loses trailing zeros in formula bar
 

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" wrote:

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

GKeyedr wrote:
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

number entered in cell loses trailing zeros in formula bar
 

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.
--
David Biddulph

GKeyedr wrote:
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" wrote:

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

GKeyedr wrote:
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
Rowing web pages at
http://www.biddulph.org.uk/

number entered in cell loses trailing zeros in formula bar
 

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

"David Biddulph" wrote:

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.
--
David Biddulph

GKeyedr wrote:
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" wrote:

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

GKeyedr wrote:
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
Rowing web pages at
http://www.biddulph.org.uk/