View Single Post
  #5   Report Post  
bj
 
Posts: n/a
Default

try
=basename&text(num+row(),"0000")
where basename is the initial part of the image identifier and num is the
correction factor to the row number to make it say what you want.
copy this and paste special value over the topof it.

"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