| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers not correct | New Users to Excel | |||
| cannot enter correct numbers in cells | Excel Worksheet Functions | |||
| formating numbers to text in columns | Excel Discussion (Misc queries) | |||
| auto correct numbers with dates | Excel Worksheet Functions | |||
| Alphabetical list of Numbers are not correct! | Excel Discussion (Misc queries) | |||
Linear Mode
