P
Paul K.
I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please
12345678911
12345 678911
How do I do this please
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pinmaster
Use a custom format like.... # ###### or 0 000000
HTH
Jean-Guy
HTH
Jean-Guy
A
Anne Troy
Format-->Cells, Custom and type 00000 000000
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
P
Paul K.
I tried this already, but I thought that I would give it another go.
Unfortunately the numbers don't change, I have no security on the worksheet
and have read and write permissions. Any other ideas? Would be appreciated!
Paul K.
Unfortunately the numbers don't change, I have no security on the worksheet
and have read and write permissions. Any other ideas? Would be appreciated!
Paul K.
A
Anne Troy
Likely, then, they are formatted as text.
Format the cells as numbers, with that custom format.
If that doesn't work, see "Data Isn't Recognized..."
http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Format the cells as numbers, with that custom format.
If that doesn't work, see "Data Isn't Recognized..."
http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
P
Pete
Hi Paul,
there should also be a leading zero if the call is to a landline or
mobile number, so you could do this at the same time using this
formula:
="0"&LEFT(A1,4)&" "&TRIM(RIGHT(A1,LEN(A1)-4))
assuming your numbers start in A1. Copy this formula down as necessary
- the first 5 characters (including the 0) will be separated by a space
from the rest of the number.
If you have overseas numbers ("00") or DQ numbers, the formula would
need to be modified.
Personally, I think phone numbers should be treated as text - you are
not likely to want to do any arithmetic on them!
Hope this helps.
Pete
there should also be a leading zero if the call is to a landline or
mobile number, so you could do this at the same time using this
formula:
="0"&LEFT(A1,4)&" "&TRIM(RIGHT(A1,LEN(A1)-4))
assuming your numbers start in A1. Copy this formula down as necessary
- the first 5 characters (including the 0) will be separated by a space
from the rest of the number.
If you have overseas numbers ("00") or DQ numbers, the formula would
need to be modified.
Personally, I think phone numbers should be treated as text - you are
not likely to want to do any arithmetic on them!
Hope this helps.
Pete