Try a Custom (near the bottom of the category list) number format of:
000000

You could also preformat the cell as text, then do the data entry with the
leading 0's

or start your string with an apostrophe:
'000002

The top suggestion allows you to just type 2 and see 000002 in the worksheet
cell (not the formula bar). And it keeps the value numeric (probably not
important with check numbers).





Pet710 wrote:

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 ???

--

Dave Peterson