View Single Post
  #5  
Old 10-May-2006, 10:19
antonye's Avatar
DSC Member antonye antonye is online now
Administrator
Webteam
MotoGP God
Bikes: 748S, HM1100S, V4SP, Was: DD-A #111
 
Posts: 13,082
Join Date: Feb 2002
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
Quote+Reply