software

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.

Under Cell Formatting, select Custom and enter: 0000

HTH,
Elkarquot;Headfishquot; wrote:

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

Hi
Format Cells Number Custom 0000

HTH
CarimThank you, I had looked at Custom and thought that would overwrite the
digits. It worked great. I appreciate it.

quot;Elkarquot; wrote:

gt; Under Cell Formatting, select Custom and enter: 0000
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Headfishquot; wrote:
gt;
gt; gt; I have a field with a bunch of numbers from 1 to 1000. They need to be
gt; gt; displayed as 0001, 0002...0999, 1000. I was looking for a function or number
gt; gt; formatting way of accomplishing this.

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.

quot;Headfishquot; wrote:

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

Use TEXT(value,quot;0000quot;)
where values is the value is the cell you want to include with 4 digits--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Headfishquot; gt; wrote in message
...
gt; Argh, one more step. What I'm actually doing is creating a list of image
gt; links. The images are preceded by an address (e.g.,
gt; C:\mydocuments\mypictures\), then a static portion of the name (e.g. DSC),
gt; followed by the number (formatted to be four digits preceded by zeroes,
gt; which
gt; you helped me with) and finally type (e.g., .jpg).
gt;
gt; I am trying to concatenate the Address, file number (formatted as 4
gt; digits)
gt; and type to create a working address. I attempted to cut and
gt; paste-special
gt; the number column with values and formats. But when it concatenates it
gt; drops
gt; the zeroes creating an address that doesn't work. In other words, I get
gt; C:\mydocuments\mypictures\DSC1.jpg, instead of
gt; C:\mydocuments\mypictures\DSC0001.jpg.
gt;
gt; quot;Headfishquot; wrote:
gt;
gt;gt; I have a field with a bunch of numbers from 1 to 1000. They need to be
gt;gt; displayed as 0001, 0002...0999, 1000. I was looking for a function or
gt;gt; number
gt;gt; formatting way of accomplishing this.
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.

quot;Peo Sjoblomquot; wrote:

gt; Use TEXT(value,quot;0000quot;)
gt; where values is the value is the cell you want to include with 4 digits
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Headfishquot; gt; wrote in message
gt; ...
gt; gt; Argh, one more step. What I'm actually doing is creating a list of image
gt; gt; links. The images are preceded by an address (e.g.,
gt; gt; C:\mydocuments\mypictures\), then a static portion of the name (e.g. DSC),
gt; gt; followed by the number (formatted to be four digits preceded by zeroes,
gt; gt; which
gt; gt; you helped me with) and finally type (e.g., .jpg).
gt; gt;
gt; gt; I am trying to concatenate the Address, file number (formatted as 4
gt; gt; digits)
gt; gt; and type to create a working address. I attempted to cut and
gt; gt; paste-special
gt; gt; the number column with values and formats. But when it concatenates it
gt; gt; drops
gt; gt; the zeroes creating an address that doesn't work. In other words, I get
gt; gt; C:\mydocuments\mypictures\DSC1.jpg, instead of
gt; gt; C:\mydocuments\mypictures\DSC0001.jpg.
gt; gt;
gt; gt; quot;Headfishquot; wrote:
gt; gt;
gt; gt;gt; I have a field with a bunch of numbers from 1 to 1000. They need to be
gt; gt;gt; displayed as 0001, 0002...0999, 1000. I was looking for a function or
gt; gt;gt; number
gt; gt;gt; formatting way of accomplishing this.
gt;
gt;
gt;