Shut off / disable a constant?

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

Gord Dibben

Preface the 11-25 with an apostrophe.

Else Excel sees 11-25 as a valid date.


Gord Dibben MS Excel MVP
 
G

Gary''s Student

Put an apostrophe (single quote) in front of the value or format the cell to
Text before making entries
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keeping cell references constant 1
Rearrange numbers from a column in a different order in a second c 14
Named Ranges vs. Constant Addresses, sheet protection, Guidance. 1
LOOKUP A VALUE IN A TABLE AND RETURN VALUE OF FIRST ROW IN THATCOLUMN 3
matches 3
Look Up Values Within a Range 1
Access denied while adding a NamedProperty 0
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2

Top