Create number format for 4 digit integer preceded by zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thank you, I had looked at Custom and thought that would overwrite the
digits. It worked great. I appreciate it.
 
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.
 
All three of you were very helpful. Guess this wasn't as complicated as I
thought but help searches just weren't getting me there. Thank you.
 
Back
Top