Soldato
- Joined
- 7 Feb 2004
- Posts
- 3,072
I wonder if anyone can help me.
I make Bath Bombs and Soap and I have to batch number my products.
I do this by simply inserting the date on the label and from this I can track ingredients that I used.
However when I do an insert date /time from microsoft word I get it in this format: 2006-10-26
The only problem with this is I might have it in stock for a month before I send it out and people might think its not as fresh as they'd like, obviously it is still absolutely fine.
I would rather it be more like 061026, similair but not as obvious to the customer that it is the date.
Is there a way to get this format, maybe using excel?
Thanks
I make Bath Bombs and Soap and I have to batch number my products.
I do this by simply inserting the date on the label and from this I can track ingredients that I used.
However when I do an insert date /time from microsoft word I get it in this format: 2006-10-26
The only problem with this is I might have it in stock for a month before I send it out and people might think its not as fresh as they'd like, obviously it is still absolutely fine.
I would rather it be more like 061026, similair but not as obvious to the customer that it is the date.
Is there a way to get this format, maybe using excel?
Thanks