date
 

Hi
i have imported a CSV file into excel
this file has a column containing dates
this column is formatted mm/dd/yyyy hh:mm:ss

how can i change this format to dd/mm/yyyy


i have tried copying and formatting the column to dd/mm/yyyy but still
leaves the hh:mm:ss

any ideas

thanks

kev

date
 

Looks like your data got imported like text...

Try this...
Enter 1 in any blank cell not in the column with dates...
Copy that cell
Select the column with dates
Choose Edit-Paste Special and check agains 'Multiply' and click OK.
Now format your column if you have not already done so the way you want...

The above should convert your data to number format.

"kevcar40" wrote:

Hi
i have imported a CSV file into excel
this file has a column containing dates
this column is formatted mm/dd/yyyy hh:mm:ss

how can i change this format to dd/mm/yyyy


i have tried copying and formatting the column to dd/mm/yyyy but still
leaves the hh:mm:ss

any ideas

thanks

kev
.