suppose your first tel no. is in B4 use this formula in C4
=IF(LEFT(B4,1)="3","0"&RIGHT(B4,3),B4)
copy this fomula down
replaced number will be in text format and others in number format in C
you can format all C as text if required

OhhAhh wrote in message
...
I have a sheet with old phone numbers on it. The numbers all have a
leading
3 (ie 3476) which I want to replace with a 0 (ie 0476). Of course if I do
a
regular find and replace it will replace all 3's within the numbers not
just
the leading one. Can someone out there tell me what the best way to
achieve
this is.

Thanks

Graeme