Correct formating for columns with numbers such as 01, 02, 03 etc
 

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.

Correct formating for columns with numbers such as 01, 02, 03 etc
 

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

Correct formating for columns with numbers such as 01, 02, 03 etc
 

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.