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.
|