Excel Dropping Zero's

  The Sweeper 15:53 11 Aug 2005
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 2005

Format the cells as 'Text' cells.

  Bagsey 15:57 11 Aug 2005

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 2005

As always your help is appreciated.

  wiz-king 16:05 11 Aug 2005

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

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?