G
Guest
Hi,
I'm trying to create an Excel form to generate a quotation for my customers.
I like to have quotation number extracted from today's date e.g. if I
generate quote on 30Dec06 then prefix of quote number could be 301206-xx
I have tried to use =TODAY() date function but everytime I open excel file
it changes to today's date.
Is there any way I can extract the contents of today's date and paste them
in a cell and once pasted should never change.
Thanks in advance.
Regards,
Kevin
kksmith67 at yahoo.com
I'm trying to create an Excel form to generate a quotation for my customers.
I like to have quotation number extracted from today's date e.g. if I
generate quote on 30Dec06 then prefix of quote number could be 301206-xx
I have tried to use =TODAY() date function but everytime I open excel file
it changes to today's date.
Is there any way I can extract the contents of today's date and paste them
in a cell and once pasted should never change.
Thanks in advance.
Regards,
Kevin
kksmith67 at yahoo.com