Excel help......!!

[ratboy]

I have a database with some phone numbers in, but some are like this:

129885671

Anyone know how i can create a space after the 4th number?

Much appreciated if anyone can help

 

[ratboy]

Thanks all snorted now.

 

[The Ferryman]

Change the cell format to text, rather than numerical, that should allow you to type spaces, or anything else, it will also allow you to put a zero at the front if you need one.

Regards

Bruce

 

[Admin]

or you can add a zero by putting a ' in front of it