If your date is in A1, use this formula:

=TEXT(A1,"mmddyy")

This assumes only one order per day.

Hope this helps.

Pete

On Feb 23, 8:19 pm, Gina Hastings <Gina
wrote:
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?