Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import with out chaning to a date 2/10/02 ends up 2/10/2002
When I import data from a file, it changes a column for numbers to a date.
how do I stop this from happening IE; example of the data column is 2 /10/ 02 thru 2/ 10 /23 but XLS changes this to 2/10/2002 thru 2/10/2023. I does this in all areas except ones that start with a 0 (because there is no month ) My data range is 0 /03 /0 thru 12 /12 /23. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import with out chaning to a date 2/10/02 ends up 2/10/2002
Gccurit,
If your data has no mathamatical significants, you can change the format of the cells that you are entering data into to "Text". Format Cells Catagory: Text ~Ryan -- Silverbird Designs @ www.silverbirddesigns.com Fighting Texas Aggie Class of 2009 "gccurtis" wrote: When I import data from a file, it changes a column for numbers to a date. how do I stop this from happening IE; example of the data column is 2 /10/ 02 thru 2/ 10 /23 but XLS changes this to 2/10/2002 thru 2/10/2023. I does this in all areas except ones that start with a 0 (because there is no month ) My data range is 0 /03 /0 thru 12 /12 /23. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Import into Excel 2002 | Excel Discussion (Misc queries) | |||
filter using "ends with" and 3 choices? Ex: ends with 1,2 or3 | Excel Worksheet Functions | |||
how do I delete a row automatically after each date ends | Excel Discussion (Misc queries) | |||
workdays formula ends on weekend date | Excel Worksheet Functions | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) |