Administrator
Webteam
MotoGP God
Bikes: 748S, HM1100S, V4SP, Was: DD-A #111
Posts: 13,088
Join Date: Feb 2002
Location: Back in Essex
Mood: Passion Killer
Right-Click the cell then pick "Custom" from the Category for the cell format.
In there it should automatically pick the format of "00000000" but you can type it in if needed.
In formatting, 0 is a forced digit (inc. leading zeros) and # is an optional number, so wouldn't include leading zeros.
Eg:
01234 as 00000 = 01234
01234 as ##### = 1234