| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i remove the auto date function from a cell to allow # rang
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i remove the auto date function from a cell to allow #rang
Format the cell as Text, that should work.
hth Carlo On Jan 8, 5:51*pm, SKJ18 wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i remove the auto date function from a cell to allow # rang
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. -- David Biddulph "SKJ18" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove from excel automatic date function? | New Users to Excel | |||
| How do I turn off the Auto Date function in Excel | Excel Worksheet Functions | |||
| How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
| how do i set an auto date function in excel or word? | Excel Discussion (Misc queries) | |||
| how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Hybrid Mode
