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.
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.