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.