Numbers as text in excel

Giganews Newsgroups
Subject: Numbers as text in excel
Posted by:  Keyed4U (keyed…@aol.com)
Date: 16 Oct 2003

I have a file that is created via an online shopping cart, it saves the file as
an excel (.xls) file and does so just nicely. The problem is in the numbers.
Rather than converting a text file to excel and formatting everything as text,
I have to have the part numbers formatted as they are in a text file. All
leading zeros must stay intact.

Example:

txt file:

0012345789    This is the part desc.    10.99    1(qty)    10.99
1758961233    This is another desc    1.00    3    3.00
0983201214    This is yet another    100.89    1    100.89

in the xls file it auto-formats as this:

12345789    This is the part desc.    10.99    1(qty)    10.99
1758961233    This is another desc    1    3    3
983201214    This is yet another    100.89    1    100.89

The problem is that 00123456789 and 123456789 might be 2 different items in the
database, and for the number to be missing any relevant leading zeros would
cause the system to order the wrong part.

The question....Is there a way to designate in the file, as it is being
created, that the numbers be treated as text regardless?

Thanks.

Jeff

Replies