Add a leading zero

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
D

Dave Peterson

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)
 
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



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)
Click to expand...
 
Back
Top