Add space to phone no's

I would like to add a space to a column of UK phone no's
12345678911
12345 678911
How do I do this please

Use a custom format like.... # ###### or 0 000000

HTH
Jean-Guy

"Paul K." wrote:

> I would like to add a space to a column of UK phone no's
> 12345678911
> 12345 678911
> How do I do this please

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

"Paul K." <PaulK@discussions.microsoft.com> wrote in message
news:D1870C9F-2AA3-4894-8D35-D2746F7B13D0@microsoft.com...
>I would like to add a space to a column of UK phone no's
> 12345678911
> 12345 678911
> How do I do this please

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." <PaulK@discussions.microsoft.com> wrote in message
> news:D1870C9F-2AA3-4894-8D35-D2746F7B13D0@microsoft.com...
> >I would like to add a space to a column of UK phone no's
> > 12345678911
> > 12345 678911
> > How do I do this please
>
>
>

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." <PaulK@discussions.microsoft.com> wrote in message
news:A7E1EEA8-4BD9-4EE2-9A1F-7774DDA75490@microsoft.com...
>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." <PaulK@discussions.microsoft.com> wrote in message
>> news:D1870C9F-2AA3-4894-8D35-D2746F7B13D0@microsoft.com...
>> >I would like to add a space to a column of UK phone no's
>> > 12345678911
>> > 12345 678911
>> > How do I do this please
>>
>>
>>

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