thinking aloud.
1) export / import as a text field
2) single quote at the front of the field
How are you importing / exporting?
Eric Dawson
From: Nathan Shaw <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: cf to excel formatting problem
D
If you open the file directly into excel, this happens. (I deal with a lot
of UPC's with leading zeros). However, if you open excel, then import text
file, you have the opportunity to tell it how to treat each column
(selecting text for your zip column) and everything is then cool.
All else fails
I am exporting some data to Excel and one of the
fields is zip code. Excel is stripping all leading 0's
(zeros) off of the zip codes. I need it to leave the
zip code alone, i.e. treat it as text instead of a
number. Any ideas anyone?
So far, I have tried:
1) Using an obscure ASCII char in front o
3 matches
Mail list logo
