Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Headfish
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

Under Cell Formatting, select Custom and enter: 0000

HTH,
Elkar


"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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

Hi
Format Cells Number Custom 0000

HTH
Carim

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Headfish
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

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

"Elkar" wrote:

Under Cell Formatting, select Custom and enter: 0000

HTH,
Elkar


"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.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Headfish
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

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.



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Headfish" wrote in message
...
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.



  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Headfish
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero

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.

"Peo Sjoblom" wrote:

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Headfish" wrote in message
...
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 07:16 PM
Change number format from text to number? Scot New Users to Excel 2 December 1st 05 05:15 PM
How do I format a cell for a custom part number? PJ Excel Discussion (Misc queries) 4 March 3rd 05 04:57 AM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 02:50 AM


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"