Excel Dropping Zero's

  The Sweeper 15:53 11 Aug 05
Locked

I want to compile a list of mobile phone numbers but when I enter the number in a cell and enter it drops the initial '0'. How can I get the cell to keep it?

  Shas 15:56 11 Aug 05

Format the cells as 'Text' cells.

  Bagsey 15:57 11 Aug 05

I suspect that you are entering them as numbers ie. Numerical values. Enter them as text that should sort it for you.

  The Sweeper 16:04 11 Aug 05

As always your help is appreciated.

  wiz-king 16:05 11 Aug 05

click on the column to highlight it/format cells/ general/ change to 'text'.

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

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…