Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Hi,
I have extracted a data from a tool as xls, which contains dates with time stamp but the dates are mixed in DD-MM-YY as well as MM-DD-YY in the same col. How can i coenvert all the dates in that particular col to DD-MM-YY or MM-DD-YY format. Can any one help me on this? -CNS |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Hi,
the dates are mixed in DD-MM-YY as well as MM-DD-YY in the same col How would we with a formula decide what this date is? 06-07-2009 I think it's 6 July 2009 but there is an equally strong argument to make it 7 June 2009. I think you have a major problem! Mike "Christopher Naveen" wrote: Hi, I have extracted a data from a tool as xls, which contains dates with time stamp but the dates are mixed in DD-MM-YY as well as MM-DD-YY in the same col. How can i coenvert all the dates in that particular col to DD-MM-YY or MM-DD-YY format. Can any one help me on this? -CNS |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
If your dates are real Excel dates (numbers formatted as dates) and not text
strings, VBA can help: If ActiveCell.NumberFormat = "dd-mm-yy" Then _ ActiveCell.NumberFormat = "mm-dd-yy" Apply it to the required range! Regards, Stefi €˛Christopher Naveen€¯ ezt Ć*rta: Hi, I have extracted a data from a tool as xls, which contains dates with time stamp but the dates are mixed in DD-MM-YY as well as MM-DD-YY in the same col. How can i coenvert all the dates in that particular col to DD-MM-YY or MM-DD-YY format. Can any one help me on this? -CNS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |