how do i add a 0 in front of an existing range of numbers, I have a phone
system that has a lot of speed dials, the numbers will only work if there is
a 0 at the start of each number. Wat too many to do one at a time.
Can anyone help with this one?

Cheers

On Dec 27, 5:31*am, semb1960
wrote:
how do i add a 0 in front of an existing range of numbers, I have a phone
system that has a lot of speed dials, the numbers will only work if there is
a 0 at the start of each number. Wat too many to do one at a time.
Can anyone help with this one?

Cheers

Hi ,

Arrange the data in a Column.Eg - in column A.
If your data is in A1 Just enter -

="0"&A1

You can copy the same till the end.

Thanks
Thyag