View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa
 
Posts: n/a
Default Zero starts of a number

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.