Hey Guys,
Can anyone help me with this Excel query or point me in the right direction?
I am fairly new to Excel but I've been trying to edit this data from the forex tester database. It is in .CSV so I import it into Excel but I'd like to change the date and time columns so they are a little more usable. This is how it appears after import:
XAGUSD200101022309004.574.574.574.574
But I'd like to have it like this:
XAGUSD2001:01:0223:09:004.574.574.574.574
I have tried just editing one cell and dragging down but I don't think it likes duplicates so it seems to automatically change the dates to go in series and as this is is M1 data there are a lot of date duplicates.
Any help would be much appreciated.
James.
Can anyone help me with this Excel query or point me in the right direction?
I am fairly new to Excel but I've been trying to edit this data from the forex tester database. It is in .CSV so I import it into Excel but I'd like to change the date and time columns so they are a little more usable. This is how it appears after import:
XAGUSD200101022309004.574.574.574.574
But I'd like to have it like this:
XAGUSD2001:01:0223:09:004.574.574.574.574
I have tried just editing one cell and dragging down but I don't think it likes duplicates so it seems to automatically change the dates to go in series and as this is is M1 data there are a lot of date duplicates.
Any help would be much appreciated.
James.