One way:

Put something like this in the first cell,

MyPic_0001

then drag the fill handle (lower right corner of the cell) down as far
as needed.


In article ,
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?