Home |
Search |
Today's Posts |
#1
|
|||
|
|||
stop changing data to date
When I type data ranging from 3-6 it automatically changes this to the date
of March 6 and that's not what I want. How do I stop this insanity?! |
#2
|
|||
|
|||
either preformat the cell as Text (so that XL doesn't try to parse it),
or prefix the data with an apostrophe to indicate to the parser that what follows is text: '3-6 In article , "Sara" wrote: When I type data ranging from 3-6 it automatically changes this to the date of March 6 and that's not what I want. How do I stop this insanity?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel |