Appending leading zeros to phone numbers

Dear colleagues, I wonder if anyone can help me,

I have received a spreadsheet with a list of names and phone numbers, but as it has clearly been saved before with this as number data, all the leading zeros are chopped off! I need to use this data in text broadcast software that can't cope with this incompletion.

Is there any simple way to insert either a 0 or a +44 in front of all the numbers in this column? Or am I doomed to RSI and a headache doing it manually?!

Many thanks, in anticipation,

Cazz

="0"&A1

This will add a 0 before the number and it will be converted to text, which is what it sounds like you need. You can also insert a +44 in front if it similarly:

="+44"&A1

Hi,

This may work, if the phone number is in a1 then insert a column next to it and copy this formula down:
=(0&A1)

to get +44 i'm struggling, you could use =(44&A1) but i'm struggling to get the plus sign to show on my trials.