View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ragtime Phil Ragtime Phil is offline
external usenet poster
 
Posts: 1
Default Some Cells display text others dates in the same column

I imported a .csv file into Excel. One column contains the SKU # of a
product. All my SKU's are formatted as x-xxxx. However some of the cells in
the column display the SKU as it should, but many (45 out of 170) are
displayed as a date format mmm-yy. Each one of the 45 is different. The cells
in question show up as "custom" and when I try to change it to "text" I get a
completey different number than the SKU I need. Somebody please help.