View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gccurtis gccurtis is offline
external usenet poster
 
Posts: 1
Default 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.