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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac