But it ONLY works if the first digit is 3. If it isn't, and 3 occurs later in
the number, it will fail. Another approach if the data is numeric:

=IF(A12999,A1-3000,A1)


On Thu, 3 Mar 2005 06:19:05 -0800, OhhAhh
wrote:

Thanks mate. I tried this and it worked.

"Aladin Akyurek" wrote:

=SUBSTITUTE(A1,"3","0",1)

OhhAhh wrote:
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