I have to create a formula that will generate a job number for each new
job that i enter. In this format 05-169. The first 2 digits are the
year and the last three need to be generated.

Using Col A as your JobNo enter into Cell A3:

=IF(ISBLANK(B3),"","05-"&VALUE(RIGHT(A2,3)+1)) and Copy Down

As you enter New job info in cells B3 and downward
Your Col A
Job No will
Display incrementally.

HTH





wrote in message
oups.com...
I have to create a formula that will generate a job number for each new
job that i enter. In this format 05-169. The first 2 digits are the
year and the last three need to be generated.