When I try to put a string of 18 digits in a column (similar to this
350001660334434123) the last three digits change to 000 (making the number
350001660334434000), I have change the column to format in 'General' but this
throws up an error message and nothing else seems to give me what I need.
Any help would be appreciated.

Put apostrophe in front, Excel only retains 15 significant digits of a
number.

Sorehead wrote:

When I try to put a string of 18 digits in a column (similar to this
350001660334434123) the last three digits change to 000 (making the number
350001660334434000), I have change the column to format in 'General' but this
throws up an error message and nothing else seems to give me what I need.
Any help would be appreciated.

You have two options:

1. format the cells as Text before entering the values
2. enter an apostrophe as the first character typed
--
Gary''s Student - gsnu200750


"Sorehead" wrote:

When I try to put a string of 18 digits in a column (similar to this
350001660334434123) the last three digits change to 000 (making the number
350001660334434000), I have change the column to format in 'General' but this
throws up an error message and nothing else seems to give me what I need.
Any help would be appreciated.

Format as text or precede the entry with an apostrophe '
If you look up specifications in help you will see that Excel
has 15 digits of precision and will truncate any digits after that to zero


--


Regards,


Peo Sjoblom


"Sorehead" wrote in message
...
When I try to put a string of 18 digits in a column (similar to this
350001660334434123) the last three digits change to 000 (making the number
350001660334434000), I have change the column to format in 'General' but
this
throws up an error message and nothing else seems to give me what I need.
Any help would be appreciated.

Gary''s wrote on Tue, 16 Oct 2007 07:21:00 -0700:

GsS You have two options:

GsS 1. format the cells as Text before entering the values
GsS 2. enter an apostrophe as the first character typed

You might have emphasized that both options produce text ;-)


?? When I try to put a string of 18 digits in a column
?? (similar to this 350001660334434123) the last three digits
?? change to 000 (making the number 350001660334434000), I
?? have change the column to format in 'General' but this
?? throws up an error message and nothing else seems to give
?? me what I need. Any help would be appreciated.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not