Import with out chaning to a date 2/10/02 ends up 2/10/2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top