Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If you are only concerned about how it looks (not changing the value), you can
give that cell (column of cells???) a custom format: Select the column format|cells|number tab|custom 00000 (as many 0's as you want digits to display) yahoo wrote: I have a column of numbers. I need to place a zero in front of them Instead of doing each cell manually - is there a way excel can automatically place a 0 in front of them number? Thanks -- Dave Peterson |
#2
|
|||
|
|||
Add a leading zero
I have a column of numbers.
I need to place a zero in front of them Instead of doing each cell manually - is there a way excel can automatically place a 0 in front of them number? Thanks |
#3
|
|||
|
|||
as long as the number stays in number format
On Sat, 12 Mar 2005 08:44:25 -0600, Dave Peterson wrote: If you are only concerned about how it looks (not changing the value), you can give that cell (column of cells???) a custom format: Select the column format|cells|number tab|custom 00000 (as many 0's as you want digits to display) yahoo wrote: I have a column of numbers. I need to place a zero in front of them Instead of doing each cell manually - is there a way excel can automatically place a 0 in front of them number? Thanks |
#4
|
|||
|
|||
Then you should be fine.
What happened when you tried it? yahoo wrote: as long as the number stays in number format On Sat, 12 Mar 2005 08:44:25 -0600, Dave Peterson wrote: If you are only concerned about how it looks (not changing the value), you can give that cell (column of cells???) a custom format: Select the column format|cells|number tab|custom 00000 (as many 0's as you want digits to display) yahoo wrote: I have a column of numbers. I need to place a zero in front of them Instead of doing each cell manually - is there a way excel can automatically place a 0 in front of them number? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
Leading zeros | Excel Discussion (Misc queries) | |||
How do I retain leading zero zip code formatting when saving as a. | Excel Discussion (Misc queries) | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
CSV leading zeroes | Excel Discussion (Misc queries) |