Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|