If *all* the numbers you want to enter will be 6 digits you can use a custom
number format of 000000.

Or, you can enter the digits as *text* be either formatting the cell(s) as
TEXT or by preceding the entry with an apostrophe like '000002. The
apostrophe will not be displayed in the cell.

--
Biff
Microsoft Excel MVP


"Pet710" wrote in message
...
I am trying to enter a cheque number in a cell ie 000002, when I move from
the cell it comes up as just "2". Have tried everything in format cells,
number ???