[abbyt1904]

Hi

Please can someone help. I am trying to convert a list of 16 digit numbers from text into general so that I can do a v-lookup from another spreadsheet.
I am highlighting the column where I want to paste the numbers and formatting as custom with 16 #'s, pasting my original data into a notepad and pasting it into the new pre-formatted column.

Annoyingly, Excel is changing 4476707465712132 into 4476707465712130 which is driving me mad! I've tried using a new spreadsheet and lots of other things and it doesn't help. Now realised if I just randomly enter 16 digits into a cell, what displays after I hit return isn't what I've typed.

Please help!
Thanks
Abby

[etaf]

see here
http://support.microsoft.com/kb/65903

only retains 15 digits