I have some FOREX historical data in .csv files. Here is a sample:
Code: Select all
Time,Ask,Bid,AskVolume,BidVolume
2007.05.21 07:27:28,1.972,1.9718,10.8,10.8
2007.05.21 07:27:28,1.972,1.9718,10,5.6
2007.05.21 07:27:29,1.972,1.97175,10,26
Is it possible to "merge" the date & time fields using a "yyyy.mm.dd hh:mm:ss" custom format?
Many thanks,