most common solution is to add ' before the number (apostrophe).

Bobby

"LennyD" wrote in message
...
I need to generate a spreadsheet column that has a fixed number of digits
to
the left of the decimal. I need to fill with leading zeroes if number
smaller than number of digits. Thanks.