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

Format cell as CUSTOM =00000000 where number of zeros is maximum number of
digits in number

HTH

"Lisa" wrote:

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.