Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Date Stored as Text with VBA in many Workbooks
Hello All,
I am using Windows XP/Office 2003 I have many workbooks stored in C:\Temp All these work books have date stored in mixed format in two columns viz Column A and Column D as follows: 12/31/06 ---- stored as text 13/1/06 15/1/06 1/16/06 ---- stored as text 17/1/06 20/1/06 As can be seen from above data sample the dates are stored in mixed format. I have run the following macro which works for Column A only (for Column D I need to change the Range every time and there are many workbooks so it is very time consuming process Sub test() With ActiveSheet.Range("A1:A100") ..NumberFormat = "dd/mm/yyyy" ..Value = .Value End With End Sub My requirement is to have a macro to open all the workbooks one after another in Folder C:\Temp and run the macro on Sheet1 in Columns A and D and convert the dates stored in mixed format to proper date format Can this be achieved? Thanks in advance Rashid Khan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert dates stored as text | Excel Discussion (Misc queries) | |||
Need help converting Number stored as Text to Date | Excel Discussion (Misc queries) | |||
convert value stored as text to logical refrence value! | Excel Worksheet Functions | |||
how do i convert a number stored as text to a numb in a vba loop | Excel Programming | |||
Date stored as Text | Excel Discussion (Misc queries) |