Can I get 0700 to appear as 0700 in a cell?

From: "Todd" <Todd@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 1 Aug 2005 14:01:04 -0700

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?
.

Follow-Ups:
- Re: Can I get 0700 to appear as 0700 in a cell?
  - From: RagDyer
- RE: Can I get 0700 to appear as 0700 in a cell?
  - From: Kelly
- Re: Can I get 0700 to appear as 0700 in a cell?
  - From: CLR
- Re: Can I get 0700 to appear as 0700 in a cell?
  - From: Henry

Prev by Date: Re: If Statements...
Next by Date: Re: Error message when trying to insert a column
Previous by thread: Calculating Month Name
Next by thread: Re: Can I get 0700 to appear as 0700 in a cell?
Index(es):
- Date
- Thread