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