How do i remove the auto date function from a cell to allow # rang

S

SKJ18

All i want to do is type 1-10 in a cell as a number range not a date but it
always turns into jan-10 or 1/10/08

i dont want a date i want 1 thru 10 but would rather not have that much
space taken up.
 
D

David Biddulph

You can't have that treated as a range in one cell, but if you precede it by
an apostrophe, or format the cell as text before you enter the number, then
it will stay as text and won't be converted to a date.
 

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

Find the position of a date 6
Excel check if dates are under a range of week 4
Text not date 4
Automatically update a cell with a date based on anther cells date 2
Change Default Auto-Fill-In month 4
How to select the date? 4
Working out a future date with formulas 3
Add 45 days to a date.... 3

Top