Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
how to get the random date between the start date and the end date? | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |