Thread: Need step by step to add invoice numbering to excel template
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
  
Posts: 3,365
Default Need step by step to add invoice numbering to excel template
Start with this site - McGimpsey probably has the best explanation of how to
get it done around.
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

You could put AM in a cell, right aligned, and the number returned using his
method in the cell next to it, left aligned, and it would look like AM8023.

"rmt" wrote:

I created a template in excel, now i need to create invoice numbering
starting with AM8023. I am new to 2007, please give me step by step
procedures, Please.
Reply With QuoteReply With Quote