Trying to open a CSV in open office - but it alters the data. Here is the the CSV in its raw format (opened in Notepad);
10-1001,product name 1,
10-1001-020,product name 2,
10-1001-030,product name 3,
When I open this in OpenOffice the first coloumns are changed to look like this...
01/10/01 product name 1
10-1001-020 product name 2
10-1001-030 product name 3
(Notice the first col - appears it is recognising this as a date, and trying to be helpful!)
Can anyone help with this!?
Thanks
Rob