<![CDATA[Forex Software — Data file shows date]]> 2016-07-01T08:03:11Z PunBB https://forexsb.com/forum/topic/6163/data-file-shows-date/ <![CDATA[Re: Data file shows date]]> Thank you for the help!!!

]]> https://forexsb.com/forum/user/9113/ 2016-07-01T08:03:11Z https://forexsb.com/forum/post/37244/#p37244 <![CDATA[Re: Data file shows date]]> Your Excel is set to work in Bulgarian. It doesn't accept numbers with dot '.' as numbers. If you see your screenshot, it prints the numbers in the left side of the cells. That means it accept the values as strings. This is the reason it thinks that 1.11 is November 1st.
A solution is to change the localisation settings of your windows to GB or USA.

]]> https://forexsb.com/forum/user/2/ 2016-06-30T18:13:11Z https://forexsb.com/forum/post/37234/#p37234 <![CDATA[Re: Data file shows date]]> hello i have tried that, but then it shows some number that definitely is wrong:

]]> https://forexsb.com/forum/user/9113/ 2016-06-30T16:40:09Z https://forexsb.com/forum/post/37231/#p37231 <![CDATA[Re: Data file shows date]]> Right click on the column and select Format Cells...

http://s32.postimg.org/81yksmtad/screenshot_1882.png


Than select Number:

http://s32.postimg.org/a5900at39/screenshot_1881.png

]]> https://forexsb.com/forum/user/2/ 2016-06-30T14:21:11Z https://forexsb.com/forum/post/37227/#p37227 <![CDATA[Data file shows date]]> Hello

i have an issue with the numbers inside the CSV file.
Some of the numbers are recognized as dates. Is that because of the excel that i have on the PC?

how can i change it and is it affecting the back-tests?

]]> https://forexsb.com/forum/user/9113/ 2016-06-30T14:13:35Z https://forexsb.com/forum/post/37226/#p37226