02-08-2016 11:43 PM
tools
  1. Windows Central Question's Avatar
    Windows Central Question
    After upgrading to Windows 10, csv files are no longer opening correctly in excel. Before upgrading the data would display correctly in columns. Since the upgrade the data displays all in one line instead of being in columns. Can anyone tell me what I need to change? Many thanks
    08-15-2015 01:11 PM
  2. Graeme Partridge's Avatar
    Graeme Partridge
    Just had exactly the same issue. Something during the windows 10 upgrade set the List Separator value to a " ; " instead of a comma.

    To change
    - Settings - Time & Language
    - Additional date, time & regional setting (at the bottom
    -change date, time or number formats
    - Additional settings ... (Button)

    Change the List Separator from the semi colon to a comma.
    Salvs likes this.
    08-16-2015 11:19 PM
  3. harlequine's Avatar
    harlequine
    I have encountered the same problem. Any help you got?
    08-26-2015 04:00 AM
  4. BelindaHayden's Avatar
    BelindaHayden
    Thanks so much for the help Graeme. CSV files are opening fine now that I have changed the list separator to a comma
    09-13-2015 11:38 AM
  5. BazilM's Avatar
    BazilM
    Great advice. Changing ; to , worked a treat, cheers
    02-08-2016 11:43 PM
« Windows 10 program won't refresh screen unless I right click on the taskbar?! | Why won't my Windows 10 store download anything? »

Similar Threads

  1. Outlook 2013 and the Action Centre
    By googler003 in forum Windows 10
    Replies: 1
    Last Post: 08-24-2015, 11:42 PM
  2. Windows 10 upgrade
    By Windows Central Question in forum Ask a Question
    Replies: 1
    Last Post: 08-15-2015, 01:23 PM
  3. after window ten installment video on facebook won't play how do i fix this
    By WPCentral Question in forum Ask a Question
    Replies: 0
    Last Post: 08-15-2015, 12:39 PM
  4. New Fitbit Universal Windows 10 app
    By Blkacesvf41 in forum Windows 10
    Replies: 0
    Last Post: 08-15-2015, 12:08 PM
  5. Why does the appstore point to the Windows store when clicking links?
    By Windows Central Question in forum General Phone Discussion
    Replies: 0
    Last Post: 08-15-2015, 11:43 AM
LINK TO POST COPIED TO CLIPBOARD