How come the same csv-file opens ok on some computer here at work (it autodivides itself into different columns) whilst on some computer it just opens everything into the A column?
All computers at work are _supposed_ to have the same settings.
Anyone have any idea?
Last edited by ajmufic; 02-13-2008 at 03:31 AM. Reason: Error in title (grammatical error)
Found the solution myself. It all depends on your regional settings. If your "Standards and format" are set to English the file opens ok in Excel if it is separated by commas (,) while we (in Sweden) have to have it separated by semi-colon (to have the wanted effect in Excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks