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

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

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

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