Saving to delimited - losing data

Brendon · May 21st, 2002, 10:29 PM

Hello

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

PaddyD · May 21st, 2002, 10:33 PM

Brendon,

Welcome!

Are you setting the credit card field to text?

Paddy

Brendon · May 21st, 2002, 10:43 PM

Thanks Paddy

I think I am doing that (I'm new at this stuff).

I am clicking on data/Text to columns... which sounds like it!
What should I be doing?

Thanks.

_________________

Regards

Brendon

[ This Message was edited by: Brendon on 2002-05-21 21:51 ]

RET79 · May 21st, 2002, 10:50 PM

have you tried Format->Columns -> Autofit columns?

RET79

[ This Message was edited by: RET79 on 2002-05-21 21:52 ]

PaddyD · May 21st, 2002, 10:51 PM

Once you've got the delimiters set as you want (step 2 of 3 in the 'text to columns' process, the next step (3 of 3!) allows you to specify a format for the data. Select the column that contains your crdit card numbers and select text from the 'column data format' options. Click finish!

Paddy

Brendon · May 21st, 2002, 10:54 PM

Thanks PaddyD and RET79

Paddy's was the fix. I don't want to be too forward PaddyD but .........will you marry me! You've just saved me untold hours of work and I appreciate you guys taking the time to help.

If this isn't the best board on the net, I'll eat my hat.

Thanks again and cheers.

PaddyD · May 21st, 2002, 10:56 PM

Looks like my KFC munching days are over!
Paddy

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

May 21st, 2002, 10:29 PM	#1
Brendon New Member Join Date: Mar 2002 Posts: 15	Hello 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 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 21st, 2002, 10:33 PM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Brendon, Welcome! Are you setting the credit card field to text? Paddy

May 21st, 2002, 10:43 PM	#3
Brendon New Member Join Date: Mar 2002 Posts: 15	Thanks Paddy I think I am doing that (I'm new at this stuff). I am clicking on data/Text to columns... which sounds like it! What should I be doing? Thanks. _________________ Regards Brendon [ This Message was edited by: Brendon on 2002-05-21 21:51 ]

May 21st, 2002, 10:50 PM	#4
RET79 Board Regular Join Date: Mar 2002 Location: England, UK. Posts: 526	have you tried Format->Columns -> Autofit columns? RET79 [ This Message was edited by: RET79 on 2002-05-21 21:52 ]

May 21st, 2002, 10:51 PM	#5
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Once you've got the delimiters set as you want (step 2 of 3 in the 'text to columns' process, the next step (3 of 3!) allows you to specify a format for the data. Select the column that contains your crdit card numbers and select text from the 'column data format' options. Click finish! Paddy

May 21st, 2002, 10:54 PM	#6
Brendon New Member Join Date: Mar 2002 Posts: 15	Thanks PaddyD and RET79 Paddy's was the fix. I don't want to be too forward PaddyD but .........will you marry me! You've just saved me untold hours of work and I appreciate you guys taking the time to help. If this isn't the best board on the net, I'll eat my hat. Thanks again and cheers.

May 21st, 2002, 10:56 PM	#7
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Looks like my KFC munching days are over! Paddy