How do you export/import it? If you export to a file and the open that file
with excel you can import the file through dataimport external dataimport
data, select *.* under file types and browse to open it, then the text
import wizard will open and in step 3 you can select column data format and
text
Or if you can import to a txt file then excel will pop up the text import
wizard when you open the file

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Lisa" wrote in message
...
Marcelo:
Thank you. But the problem is I cannot set up excel spreadsheet before
exporting data, so when I export data to excel spreadsheet, even I change
the
format to "TEXT", it doesn't work.
Do you know how to solve it?
Many thanks.


"Marcelo" wrote:

Hi Lisa,

Format as a text.




"Lisa" escreveu:

I export a PO# from system database to excel spreadsheet, but the PO#
starts
with zero, for example, 012345, when it exports to excel, the PO#
becomes
12345 without "0", how can I do?
Thanks.