15+Digit Exporting from an XML

[Guest]

Hi. How do I export a credit card number that ranges upto 16 digits without altering the last digit to ZERO. My source is an XML generated report and i need to place it into an excel worksheet. Your help will be most appreciated. Thanks =)

 

[Alan Cocks]

Mark

Format the cell you are exporting from as text "@"

Alan

Hi. How do I export a credit card number that ranges upto 16 digits

without altering the last digit to ZERO. My source is an XML generated
report and i need to place it into an excel worksheet. Your help will be
most appreciated. Thanks =)

 

[Ron de Bruin]

Try to change the format of the cells to text first Mark

--
Regards Ron de Bruin
http://www.rondebruin.nl

Hi. How do I export a credit card number that ranges upto 16 digits without altering the last digit to ZERO. My source is an XML

generated report and i need to place it into an excel worksheet. Your help will be most appreciated. Thanks =)

 

[Guest]

But I have no access to the formatting of the XML, coz the XML is a program already
I have just tried, though, that I place the XML numbers to Microsoft Word, then I manually put even a single space within the number. then I copy this back to Excel. then, using the concatenate formula together with special paste, everything is quite ok. however, this method is not applicable for bulk records

 

[Lady Layla]

Do you have option as to the type of output from XML? if you can, output to .txt
type file, then you can use import wiz to make that one particular column text

: Hi. How do I export a credit card number that ranges upto 16 digits without
altering the last digit to ZERO. My source is an XML generated report and i need
to place it into an excel worksheet. Your help will be most appreciated. Thanks
=)