15+Digit Exporting from an XML

M

MarkAndrew

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 =)
 
R

Ron de Bruin

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

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


MarkAndrew said:
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
Click to expand...
generated report and i need to place it into an excel worksheet. Your help will be most appreciated. Thanks =)
 
M

MarkAndrew

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
 
L

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
=)
 
Top