Format the Cell into a telephone number but using country code
 

Hello i wonder if anyone knows how to do this i do hope so

How do i change a Telephone number in a cell to have the +44 country code in
first

IE 01753 525681 change this with a format to +1753 525681 so basiclly just
dropping the first 0. if i replace 0 with +44 then all the 0 will be replaced
on the whole list of numbers

if i start the cell +44 it starts a formula

does anyone know how to do this

Please help !!

Precede the entry with an apostrophe when you enter it and the plus sign will
not try to convert to a formula. For the values already enterd I assume they
are seen as text if you have a space and a leading zero without any
formatting, for those you can use a help formula that replaces the first
character with a plus

=SUBSTITUTE(A1,LEFT(A1),"+")


Regards,

Peo Sjoblom

"Chris Quinn" wrote:

Hello i wonder if anyone knows how to do this i do hope so

How do i change a Telephone number in a cell to have the +44 country code in
first

IE 01753 525681 change this with a format to +1753 525681 so basiclly just
dropping the first 0. if i replace 0 with +44 then all the 0 will be replaced
on the whole list of numbers

if i start the cell +44 it starts a formula

does anyone know how to do this

Please help !!