You could use another column alongside and enter the formula (Presuming
column A)

="0"&A1
HTH
Nick Hodge

"Pinkwilphil" wrote:

I have transported mobile telephone numbers from our database into excel and
it has deleted all the "0" I would like to reinsert all with "0" or +44
without having to manually type this in at the beginning of every field?