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/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Paul K." wrote in message
...
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.

"Anne Troy" wrote:

Format--Cells, Custom and type 00000 000000
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Paul K." wrote in message
...
I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please