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

C

chief

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

Gord Dibben

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
 
G

Gary''s Student

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
 
Top