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
|