Opening a text or CSV file in Excel

[LISAR]

Hi,

I have a CSV file where one of the field's is a number field which has 17 characters/numbers in. The file when opening is substituting the last 2 digits as 00, instead of what they should be. Example is below.

20020407080000334

it opens in excel as

20020407080000300

Any suggestions would be greatly appreciated.

 

[PaddyD]

change the file extension to txt, open from excel - you should get the 'text to cols' dialogue box. make sure you select text as the data type for the column - the prob you've got is that the string is being interpreted as a number & is falling victim to excel's 15 digit number precision limit.

paddy