How can I display preceeding zeros on Excel worksheet?

[Guest]

I am trying to get an invoice number to appear on an Excel spreadsheet. I
must include some preceeding zeros,.ex: 000124585. Any suggestions?

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom 000000000

 

[Guest]

Put an inverted comma in font

'

Mike

 

[Guest]

You can also right click on the cells containing the invoice numbers and
select format cell and select "Text" in type.