date

K

kevcar40

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
 
S

Sheeloo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formats 1
How to customize =Now() 11
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
cell format - not automatically taking effect 4
Excel 2002: How to make the date format uniform ? 1
Convert dates stored as text 2
Excel - convert dates to text but appear as a date format 6
Delete Timestamp 2

Top