Shut off / disable a constant?

  • Thread starter Thread starter dave@aeronautics
  • Start date Start date
D

dave@aeronautics

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
 
Put an apostrophe (single quote) in front of the value or format the cell to
Text before making entries
 
Back
Top