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 !!