I get a red flag in the upper left corner letting me know that the entry (01)
is entered as text or has an apostrophy preceding it. It is listed as text
because that was the only way I could enter 01 without losing the 0. There is
not an apostrophy.

I would format the cells as Custom 00 then just enter the 1, 2, 3

Will show as 01, 02, 03 and not raise an error.


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 12:24:02 -0700, chief <(E-Mail Removed)>
wrote:

>I get a red flag in the upper left corner letting me know that the entry (01)
>is entered as text or has an apostrophy preceding it. It is listed as text
>because that was the only way I could enter 01 without losing the 0. There is
>not an apostrophy.

The red flag is only an option....If you don't want the red flag to appear
then:

Tools > Options > Error Checking > and clear the number stored as text
checkbox
--
Gary''s Student - gsnu200793


"chief" wrote:

> I get a red flag in the upper left corner letting me know that the entry (01)
> is entered as text or has an apostrophy preceding it. It is listed as text
> because that was the only way I could enter 01 without losing the 0. There is
> not an apostrophy.
>