Hi Todd -

Type in the apostrophe (') and then 0700. Excel will read it is text and
not delete the first 0. Problem is, if you need to include that sum in any
kind of mathematical formula, it won't work. But hopefully the text
formatting will work for you.

Kelly

"Todd" wrote:

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?