|And just to make life a bit more interesting,.....|
If you always want a leading zero for your number,
regardless of what you enter, IE
you enter 1234 you get 01234
then a custom format of: "0"#
will always insert a zero before your number.
if you always want two leading zeros, "00"#
Always good to know what you want before you start......