The formula below works nicely. I did notice that my number is not out to

the thousands place. The cell in my job number is custom formated as 0000,

so when 101 is entered, it displays 0101. This four digit number is what

should be added to my file number as 20080919-0101, but it displays as

20080919-101. How do I get the last four digits to display as 0101?

Also, because my YYYY, MM, and DD fields are based on =now() formula, I'm

assuming that every day I open the file, my file number will change. Is

there a simple way to get this to be a static number after it is first

created without the additional step of copy, paste special - values?