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