Scott,

I just ran it down to row 65536, no problems. There just aren't enough rows
in Excel (yet!) for it to become a problems.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"scott" wrote in message
...
Thanks Bob that looks like it will work perfect. Do you see any problems
the
larger the number gets. Last year we ran 1944 samples would anything
happen
if say this gets to 1999.
thanks again Scott
One other question. I ahve atemplate for my ss. Is there a tweak to your
formula that would replace the 2006 with the current year, for future.
When
2007 comes around I would have to reset 2006 to 2007 just wondering

thanks again scott

"Bob Phillips" wrote:

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