enter
=basename&text(num+row(),"0000")
in A1 where basename is the what you want to call the beginning of the title
and num is the correction that needs to be added to the row number to give
the number you want

"UFWPresident" wrote:

I have a large series of images to enter into an excel worksheet. One page is
over 400 another is 1100. Is there a way to enter in the base name of the
images and write a formula, or macro that will automatically add a four digit
numbering system on the end. Starting with 0001 and ending with the last
image?
--
Thank you,
UFWPresident