If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Zero Placeholders in number cell
Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For
example I have a column with number cells which calculate sequentially. I have a need for the first and subsequent numbers to have four digits (ex. 0001, 0002 etc.). The zero's of course do not show when they are entered. Is there a way to do this and still have it calculate??? Thanks in advance. -- B. Parizo |
#2
|
|||
|
|||
It's called leading zeroes. See:
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "B. Parizo" wrote in message ... Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For example I have a column with number cells which calculate sequentially. I have a need for the first and subsequent numbers to have four digits (ex. 0001, 0002 etc.). The zero's of course do not show when they are entered. Is there a way to do this and still have it calculate??? Thanks in advance. -- B. Parizo |
#3
|
|||
|
|||
Try this:
FormatCellsCustom in the type box: 0000 "B. Parizo" wrote: Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For example I have a column with number cells which calculate sequentially. I have a need for the first and subsequent numbers to have four digits (ex. 0001, 0002 etc.). The zero's of course do not show when they are entered. Is there a way to do this and still have it calculate??? Thanks in advance. -- B. Parizo |
#4
|
|||
|
|||
That was the answer. Thank you!
-- B. Parizo "David Hepner" wrote: Try this: FormatCellsCustom in the type box: 0000 "B. Parizo" wrote: Hi: Is it possible to have zero (0) placeholders in an excel 2003 cell. For example I have a column with number cells which calculate sequentially. I have a need for the first and subsequent numbers to have four digits (ex. 0001, 0002 etc.). The zero's of course do not show when they are entered. Is there a way to do this and still have it calculate??? Thanks in advance. -- B. Parizo |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy cell format to cell on another worksht and update automatical | kevinm | Worksheet Functions | 21 | May 19th, 2005 11:07 AM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
inserting data from a row to a cell, when the row number is specified by a formula in a cell | [email protected] | New Users | 2 | January 6th, 2005 07:18 AM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
trying to input number from another cell automatically | BigRay | Worksheet Functions | 1 | August 10th, 2004 04:33 PM |