View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gina Hastings Gina Hastings is offline
external usenet poster
 
Posts: 1
Default Excel: formula to generate an order number based on date

I am trying to create an order form that will generate an order number based
on the date the order is written. I would like to have the number shown
without the slashes (/). Example: If the order is written on 2/23/07, I
would like the order number to be
022307.

Is this possible?