> my data reads:
> 627
> 628
> 629,
> etc.
>
> I need to add a "0" to the front of each number. Is there an easy formula
> to do this?
>
> thanks! jane
worksheet functions >> add "0" to the beginning of each value
If it is just presentation, use a custom format of 0000.
--
HTH
Bob Phillips
> my data reads:
> 627
> 628
> 629,
> etc.
>
> I need to add a "0" to the front of each number. Is there an easy formula
> to do this?
>
> thanks! jane
worksheet functions >> add "0" to the beginning of each value
Because Excel 'ignores' leading zeros in numbers, the best way is to use
Custom Format. Highlight all affected cells, choose Format>Cells. On
the Number tab, select Custom and set the format to '0000'. Click OK.
All cells will now have a leading zero. Note that a two digit number
(e.g. 12) will have TWO leading zeros (0012).
Another option is to format the cells as text and then enter your
number with the leading zero: (e.g. 0123)