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

  • Thread starter Thread starter SKJ18
  • Start date Start date
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.
 
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

Excel check if dates are under a range of week 4
accepting most recent date across columns 10
Text not date 4
adding text according to col with equal date 2
Date range within a date range 2
Automatically update a cell with a date based on anther cells date 2
PLEASE HELP??? copy every other cell value to a range of cells 3
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Back
Top