View Single Post
  #1   Report Post  
Chris Quinn
 
Posts: n/a
Default 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 !!