date problems importing a csv file

  • Thread starter Thread starter kman
  • Start date Start date
K

kman

Hi,
I have this problem.
whe I imported a .csv to excel with dates, the excel shows the date
like a text cell in this format "9-Mar-04" when I try to change th
cell format to date, it doesn't changes it and it still remains like
string.

thank
 
Hi
try the following
- select your column with dates and assign the format
DD-MMM-YY
to it
- now select an empty cell and copy this cell
- goto 'Edit - Paste Special' and choose the action 'Add'

now you should be able to change the format as th above procedure has
converted the strings to a date format
 
Back
Top