If it is a .csv file, rename it .txt
On importing, you'll get a wizard in which you can specify the field as text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lsm" wrote in message ...
|I have huge spreadsheets that I am importing into excel which contain credit
| card numbers (16 digits). Is there any way to force Excel to recognize
| these?
|
| Thanks
| Lsm
|
| "Don Guillett" wrote:
|
| 15 max
|
| --
| Don Guillett
| SalesAid Software
|
| "vkwd7" wrote in message
| ...
| when I tried to enter number 123456789101112,the last digit ie 15th digit
| changes to 0 instead of 2.It happens with every number with morethan 14
| digits.
| I tried regional settings which seem ok to me.
| Is there a way out to enter number as number without using the text
| formatting.
| vkwd7
|
|
|
|