How can I retain leading zeroes when saving as a CSV file?

[Guest]

I use a MS Query to pull address data from an ERP package. This data
includes a numeric “location codeâ€. These location codes are 4 digits, and
some have leading zeroes. I then take the resulting .xls spreadsheet, do
some subtle formatting, and then save as a .csv for uploading to a web
server. I need to retain the leading zeroes so that when data comes back to
the ERP from the web, the location code is four digits.

I’ve tried formatting the location code as text, in hopes that the
conversion to .csv will retain the zero. No luck.

Is there anything else I should try?

 

[Lady Layla]

Change file ext to txt from csv, then when you are using the import wizard,
format the column of data as text


: I use a MS Query to pull address data from an ERP package. This data
: includes a numeric â?olocation codeâ?. These location codes are 4 digits,
and
: some have leading zeroes. I then take the resulting .xls spreadsheet, do
: some subtle formatting, and then save as a .csv for uploading to a web
: server. I need to retain the leading zeroes so that when data comes back to
: the ERP from the web, the location code is four digits.
:
: Iâ?Tve tried formatting the location code as text, in hopes that the
: conversion to .csv will retain the zero. No luck.
:
: Is there anything else I should try?
: