excel help with cell format

  Boy Zone 12:13 25 Sep 2007
Locked

I'm trying a simple task but I'm not able to complete.
I want to enter telephone numbers into a spread sheet and each time I enter eg 0121 it looses the 0. I can get around this by converting the cells to text formate but is there a better way?

  Noldi 12:23 25 Sep 2007

click here

Noldi

  Press Man 12:58 25 Sep 2007

Just type in an single quote mark first, its on the @ symbol key.

  Simsy 16:28 25 Sep 2007

if you put a space anywhere in the number, it will recognise it as text anyway. (In fact any character that isn't a 0-9 digit)

Regards,

Simsy

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?