With the 'number' of interest in E5 use the formula
="E"&TEXT(RIGHT(E5,LEN(E5)-1)+1,"00000")

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
i want to search a column for the largest number...but the numbers have an E
before them....

E05001
E05002
E05003
.
.
.
E05xxx

is it possible to find the largest one, then add one to it and give me back
that number? when the new year comes, the series will look like this:

E06001
E06002
.
.
.
E06xxx

Thanks for any input on this