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.

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.