Sorry! Adding a number to the front of a string...
Posted by Steven O'Neill on January 29, 2001 7:06 AM
I have a column of fax numbers some which do not start with a zero and others which contain a minus eg.
The correct format I need is -
I need to have a zero at the front of each number and no spaces or dashes.
Is there a way of getting Excel to take each number and add a zero if one is missing and take away a space or a dash if it's there?
Cheers in advance,