I have a worksheet containing a column of cells each containing a mobile phone number - the number in the cell is 7 digit , but needs to be 8 digit (commencing with a "0" - which is now missing ) I need to insert a 0 at the front of current string of 7 digits in each cell - I've done this before but have forgot how to do. Can you pls tell me what formula / instruction I must use to get a column with desired result - I need the phone number in correct 8 digit format for a SMS transmission program.
Bookmarks