Excel problem

  gudda96 17:34 14 Aug 2003

Hi Gang

When I type a tel no in an Excel cell eg 0208
the first 0 does not stay.

I know it is something like format/custom etc but have forgotten, can you help.

  Peter 18:31 14 Aug 2003


You could just enter the number preceding it with a single quote e.g '020 899 9999 or use the BT prefered layout of (020) 899 9999.


  Simsy 18:45 14 Aug 2003

and it orks as VoG suggests.. i.e. if you enter a number leaving a space somewhere, such as;

020 8888 8888

It keeps the leading zero.

If you don't have a space it thinks it is just a "number" and removes it.

Alternatively, you could format the cell as "text"

Good luck,



  gudda96 08:47 15 Aug 2003


You are correct, just received this and it works, thanks everyone.


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

Elsewhere on IDG sites

Amazon slashes Echo Dot price to just £24.99 to kick off Black Friday

The 51 Best Free Typefaces Every Designer Should Have

Mac mini 2018 review

Les meilleurs écouteurs et casques audio (2018)