Formatting telephone number

Posted by Danielle on March 05, 2001 1:27 AM

Hello,

I have a column showing telephone but I want to show them in international format. At the moment they look like 01254 512547. I want to remove the leading 0 and replace it with 0044 1254 512547.

Can anyone help me with a macro to do this automatically??

Thanks!!
Danielle

Posted by Dave Hawley on March 05, 2001 4:41 AM

Hi Danielle

No real need for a macro to do this, lets say your numbers are in Column A in B1 put this:

=REPLACE(A1,1,1,"0044") copy down as far as needed then Copy Column B and PasteSpecial-Values over the top of Column A.

Dave

OzGrid Business Applications