View Single Post
  #1   Report Post  
Croc001
 
Posts: n/a
Default 16 digit number wont keep alteration unless format cell to text

Using excel 2000
recieving data from client with 16 numeral characters within cells
cells show an abreviated listing for the number (2.06E+15)
When editing the the number (wanting to change the last number by 1 digit)
i.e.
2059510000000000 - change to - 2059510000000001
this change will not be kept??

I format the cell to "numbers" with no decimal point as a whole number is
required

Any ideas??
Is this number to long for excell 2000??

I'm not a big excel user

Cheers
Croc001