Excel and a numerical column

  swapper 12:14 19 Mar 08
Locked

I am using excel, one of my columns consist entirely of telephone numbers i.e. 01234 123456, I have noticed that many of the groups are slightly longer than others.
Even the same number entered twice can be of a different length.

Any idea how I can make them appear in a neat column please, i.e not slightly staggered.
I have aligned left but to no avail.

tia

  birdface 14:17 19 Mar 08

Probably nothing to do with your problem but worth a look.click here

  keef66 14:38 19 Mar 08

highlight the column and make sure all the cells have the same formatting, font size, etc

  xania 14:59 19 Mar 08

The main problem is that you have a number which starts with a zero, so that zero will vanish as soon as you close the cell - also large numbers get converted to exponential form i.e. 7.9E+09.

To overcome both these problems, either you can insert blank spaces (i.e. 0208 1234 5678) or you need to set up you cell as a <text> cell.

  VoG II 15:17 19 Mar 08

Or Format > Cells > Special > Phone Number.

  Chris the Ancient 15:22 19 Mar 08

Is that a new thing in Excel 2007? I ain't got it in 2003.

CtA

  VoG II 15:25 19 Mar 08

I have the option here with Excel 2000. I'll have to check XL2007 when I get home.

  keef66 15:38 19 Mar 08

It only appears in Excel 2003 if you select USA as location

  Chris the Ancient 18:06 19 Mar 08

Oh. I'm sticking to English (UK) and have virtually excluded all English (US) from my machine!

So that's why I don't see it.

And don't the Americans have a different phone number format to us?

  Chris the Ancient 18:11 19 Mar 08

Just had an experiment and found that system.

Trouble is that the UK has so many different ways of doing phone numbers with our 'crazy' prefixes and variable length numbers that I can't get any of them to fit into the American methodology!

  swapper 09:46 20 Mar 08

Thanks everyone, I first tried - Format > Cells > Special > Phone Number - and got a result.

thank you again.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

New Corel ParticleShop plugin now available: 11 new brushes & 6 new brush packs

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…