BrianSmith
New Member
I export data from Progress to a 'csv' file,
eg
"Home Depot", 1234.45,"00012345"
"Radio Shack", 313.23,"00313333"
"London Drugs", 3554.44,"DEBITMEMO"
When I open this csv file with Excel from within Progress, the 3rd column is losing the leading zeros. This column is alphnumeric and should retain the leading zeros. If I format the 3rd column in Excel after the file is opened, the leading zeros are still gone.
How can I get these leading zeros into Excel?
Thanks, Brian
eg
"Home Depot", 1234.45,"00012345"
"Radio Shack", 313.23,"00313333"
"London Drugs", 3554.44,"DEBITMEMO"
When I open this csv file with Excel from within Progress, the 3rd column is losing the leading zeros. This column is alphnumeric and should retain the leading zeros. If I format the 3rd column in Excel after the file is opened, the leading zeros are still gone.
How can I get these leading zeros into Excel?
Thanks, Brian