assign auto number and auto date
I try to design my own form. I want one of the cell to show today date
automaticly everytime I open my template. And I want one of another cell to assign number automaticly like invoice no. |
Krit, have a look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Krit Kasem" <Krit wrote in message ... I try to design my own form. I want one of the cell to show today date automaticly everytime I open my template. And I want one of another cell to assign number automaticly like invoice no. |
Thank you Paul, I will try.
Krit "Paul B" wrote: Krit, have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Krit Kasem" <Krit wrote in message ... I try to design my own form. I want one of the cell to show today date automaticly everytime I open my template. And I want one of another cell to assign number automaticly like invoice no. |
All times are GMT +1. The time now is 06:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com