Working in Office 2007 Excel and need to enter a range of numbers in
individual cells (e.g. 81-100, 72-80, 63-71 etc.). One of the 'ranges' is
11-25, which gets read and put in as a date in any cell in the spreadsheet.
How do I disable this feature? Have tried numerous approaches with cell
format, changing formulae, etc., to no avail. Have found nothing in Help that
addresses constants.

Preface the 11-25 with an apostrophe.

Else Excel sees 11-25 as a valid date.


Gord Dibben MS Excel MVP

On Tue, 29 Dec 2009 08:22:01 -0800, dave@aeronautics
wrote:

Working in Office 2007 Excel and need to enter a range of numbers in
individual cells (e.g. 81-100, 72-80, 63-71 etc.). One of the 'ranges' is
11-25, which gets read and put in as a date in any cell in the spreadsheet.
How do I disable this feature? Have tried numerous approaches with cell
format, changing formulae, etc., to no avail. Have found nothing in Help that
addresses constants.

Put an apostrophe (single quote) in front of the value or format the cell to
Text before making entries
--
Gary''s Student - gsnu200909


"dave@aeronautics" wrote:

Working in Office 2007 Excel and need to enter a range of numbers in
individual cells (e.g. 81-100, 72-80, 63-71 etc.). One of the 'ranges' is
11-25, which gets read and put in as a date in any cell in the spreadsheet.
How do I disable this feature? Have tried numerous approaches with cell
format, changing formulae, etc., to no avail. Have found nothing in Help that
addresses constants.