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