View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Large Digit Issues

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.