Scott,

Try this

=VALUE(2006&MOD(A1,20060)+1)

adjust for A1 to where your value is

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"scott" wrote in message
...
In my spreedsheet we have to record daily test results with an id numbered
assigned to them. To start the new year we would start with 20061. 2006
represents the year and 1 represents the first sample. I start the year
with
this number and then in the following cells my formula just adds one. This
elminates us typing in the id number so the next number would be 20062
etc. I
did not take into account that once I reached 20069 my next ID number
turned
to 20070. I need to keep the 2006 so after 20069, the next reading would
be
200610. Is there a way to do this either through formating or a different
formula.

thanks in advance
scott