Quote:
Originally posted by antonye
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 |
Yeeehaaaa, that works just fine. Many thanks guys, great info and very quick as usual. Almost tempted to chuck my slide rule and four figure tables away now
