Shut off / disable a constant?
 

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.

Shut off / disable a constant?
 

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.

Shut off / disable a constant?
 

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.