You could format the entire column as Text. That way, Excel will accept numbers from 1 to 32,767 digits and will display up to 1,024 digits. No formulae required - and you can even have leading 0s.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]