Argh, one more step. What I'm actually doing is creating a list of image
links. The images are preceded by an address (e.g.,
C:\mydocuments\mypictures\), then a static portion of the name (e.g. DSC),
followed by the number (formatted to be four digits preceded by zeroes, which
you helped me with) and finally type (e.g., .jpg).

I am trying to concatenate the Address, file number (formatted as 4 digits)
and type to create a working address. I attempted to cut and paste-special
the number column with values and formats. But when it concatenates it drops
the zeroes creating an address that doesn't work. In other words, I get
C:\mydocuments\mypictures\DSC1.jpg, instead of
C:\mydocuments\mypictures\DSC0001.jpg.

"Headfish" wrote:

I have a field with a bunch of numbers from 1 to 1000. They need to be
displayed as 0001, 0002...0999, 1000. I was looking for a function or number
formatting way of accomplishing this.