Hi all,

i have been trying to do this for quite some time now so here it is: I have a .csv spreadsheed and i want to run a macro that:

Converts the date which is in the dd/mm/yyyy hh:mm format to this format dd/mm/yyyy only (without the time)
For this I have used

*****
Range("E6").Select
Selection.TextToColumns Destination:=Range("A2"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1)), TrailingMinusNumbers:=True
*****
copyies the new date and paste it in the last column (starting K2 down)


When i download the data, the file automatically puts it in the E6 cell. I am also deleting the cell later so i have only the cell headings which includes the Date and the data (but the date column is populated)

Any help woudl be grately appreciated.