<![CDATA[Forex Software — Data file shows date]]> https://forexsb.com/forum/topic/6163/data-file-shows-date/ Fri, 01 Jul 2016 08:03:11 +0000 PunBB <![CDATA[Re: Data file shows date]]> https://forexsb.com/forum/post/37244/#p37244 Thank you for the help!!!

]]> Fri, 01 Jul 2016 08:03:11 +0000 https://forexsb.com/forum/post/37244/#p37244 <![CDATA[Re: Data file shows date]]> https://forexsb.com/forum/post/37234/#p37234 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.

]]> Thu, 30 Jun 2016 18:13:11 +0000 https://forexsb.com/forum/post/37234/#p37234 <![CDATA[Re: Data file shows date]]> https://forexsb.com/forum/post/37231/#p37231 hello i have tried that, but then it shows some number that definitely is wrong:

]]> Thu, 30 Jun 2016 16:40:09 +0000 https://forexsb.com/forum/post/37231/#p37231 <![CDATA[Re: Data file shows date]]> https://forexsb.com/forum/post/37227/#p37227 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

]]> Thu, 30 Jun 2016 14:21:11 +0000 https://forexsb.com/forum/post/37227/#p37227 <![CDATA[Data file shows date]]> https://forexsb.com/forum/post/37226/#p37226 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?

]]> Thu, 30 Jun 2016 14:13:35 +0000 https://forexsb.com/forum/post/37226/#p37226