Lenny

FormatNumberCustom

Enter the appropriate number of 0's

000000.00

Would return 000023.23 or 000002.32 or 000232.32

Gord Dibben Excel MVP

On Wed, 15 Dec 2004 09:51:06 -0800, LennyD
wrote:

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.