Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First Number in a Cell | Excel Worksheet Functions | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
number formatted cell | Excel Discussion (Misc queries) | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions |