Add a Zero to some fields

I have a dozen columns that contain phone numbers in some cells over 500 rows. As part of an import error made by myself it has knocked off the first zero. Even if I change the columns to text fields the zeros have now gone.

What I need to do I guess is use some form of formula (if statement???) where if it detects a 0 as the left most char then ignore it, but if it detects a set of numbers already in the field, I would like it to insert a zero on the far left of the number and leave the rest in place.

Any ideas anyone?

Thanks in advance

I have 500 rows and a number of columns that I need to apply this to. Please excuse my inexperience but how do I apply your solution?

Thanks & Apologies

Hi Talisa

Click on the cell where you have entered the formula, hover your mouse over the bottom right hand cell until it becomes a cross, left click, hold down your mouse key and drag up or down.
Alternatively when the you hover your mouse until it becomes a cross at the bottom right of the cell, double left click to send it down.

Hi Talisa,

Every phone no. has fixed length. Say in India mobile numbers contains 10 digits. If you have lost a zero in begining you can cross check using below formula and correct you data.
Say, cell A1 contains your phone number with 9 digits (instead of 10). Write below code in cell B1 and so on.....

Please Login or Register  to view this content.