Comma seperated to comma delimited

Brendon · May 22nd, 2002, 02:57 PM

I am trying to download comma seperated data into Excel. No problems there. I need it to be comma delimited file.

Then I go to Data/Text to columns and go through the process to make it a comma delimited file. When I get to the credit card field I select the column that contains the credit card numbers and select text from the 'column data format' options (PaddyD gave me this fix yesterday - I just can't seem to get it working today).

When I do this, the credit card number (that was fine in the comma seperated file) hides part of itself - i.e becomes 4.97848E+15.

Is there anyway I can get that full credit card number back?

Thanks for any assistance.

Al Chara · May 22nd, 2002, 03:02 PM

What PaddyD told you should work. Try starting from scratch (i.e. shut it all down and restart).

sen_edp · May 22nd, 2002, 03:02 PM

hello brendon

Format these cells with number format,not general.

Brendon · May 22nd, 2002, 03:09 PM

Thanks

As PaddyD's fix worked before it must be me!

I have got it into csv with the full number intact.

When I go to shut Excel it gives me the 3 options (1. Save in Excel format, 2. Sav echanges in existing format, 3. Close file without saving changes) - I choose '2' and then when I open the file back uo I am back to my problem again.

Al Chara · May 22nd, 2002, 03:57 PM

Have you tried option 1 or copying the worksheet to a new workbook?

Russell Hauf · May 22nd, 2002, 04:24 PM

I'll second the answer that PaddyD gave you - you definitely want text format as Excel will basically cut off the last digit when working with 16-digit numbers (which I work with daily) if they are formatted as numeric.

Brendon · May 22nd, 2002, 06:51 PM

Thanks for the answers.

Yep, I'm sure that the answer was right as I did it once!
I can get into into a csv file on the screen okay. I think the trouble begins when I go to shut Excel and get the 3 options.

I can't remember what I did the first time.

I'll keep trying!

May 22nd, 2002, 03:02 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	What PaddyD told you should work. Try starting from scratch (i.e. shut it all down and restart). __________________ Kind regards, Al Chara

May 22nd, 2002, 03:02 PM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello brendon Format these cells with number format,not general. __________________ Best Regards Andreas

May 22nd, 2002, 03:57 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Have you tried option 1 or copying the worksheet to a new workbook? __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 02:57 PM	#1
Brendon New Member Join Date: Mar 2002 Posts: 15	I am trying to download comma seperated data into Excel. No problems there. I need it to be comma delimited file. Then I go to Data/Text to columns and go through the process to make it a comma delimited file. When I get to the credit card field I select the column that contains the credit card numbers and select text from the 'column data format' options (PaddyD gave me this fix yesterday - I just can't seem to get it working today). When I do this, the credit card number (that was fine in the comma seperated file) hides part of itself - i.e becomes 4.97848E+15. Is there anyway I can get that full credit card number back? Thanks for any assistance.

May 22nd, 2002, 03:09 PM	#4
Brendon New Member Join Date: Mar 2002 Posts: 15	Thanks As PaddyD's fix worked before it must be me! I have got it into csv with the full number intact. When I go to shut Excel it gives me the 3 options (1. Save in Excel format, 2. Sav echanges in existing format, 3. Close file without saving changes) - I choose '2' and then when I open the file back uo I am back to my problem again.

May 22nd, 2002, 04:24 PM	#6
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	I'll second the answer that PaddyD gave you - you definitely want text format as Excel will basically cut off the last digit when working with 16-digit numbers (which I work with daily) if they are formatted as numeric.

May 22nd, 2002, 06:51 PM	#7
Brendon New Member Join Date: Mar 2002 Posts: 15	Thanks for the answers. Yep, I'm sure that the answer was right as I did it once! I can get into into a csv file on the screen okay. I think the trouble begins when I go to shut Excel and get the 3 options. I can't remember what I did the first time. I'll keep trying!