If you have many of them to do, such as a list of Part Numbers,
etc...........then pre-format the cells for TEXT before typing in the
numbers with the leading zeros.

Vaya con Dios,
Chuck, CABGx3



"Todd" wrote in message
...
I am trying to get the number 0700 to appear as 0700 in a cell, not as
700.
When I type it in, Excell automatically corrects what it thinks is a
mistake.
Is there a way to make it appear as 0700?