excel help with cell format

  Boy Zone 12:13 25 Sep 07
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 07

click here

Noldi

  Press Man 12:58 25 Sep 07

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

  Simsy 16:28 25 Sep 07

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.

Huawei P10 review

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

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos