Ok. That wasn't the only way I knew of...I just wasn't thinking straight
when I replied.

--

"PCLIVE" wrote in message
...
The only way I know of is to force the entry to be seen as text.

Precede your number with an apostrophe
Ex. '001234

HTH,
Paul

--

"panaga" wrote in message
...
How do I get a leading "0" to show up in a number formatted cell?