Several methods.

Precede the number entry with an apsotrophe '001234

Pre-format the cell as text.

Set up a custom format like 0000000 depending upon the number of digits in the
number.


Gord Dibben MS Excel MVP


On Fri, 17 Nov 2006 14:58:02 -0800, nobby
wrote:

How do I show Leading Zero's in Excel