| 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 |
| 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) | |||
![Christopher Naveen[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
