Forum Discussion

Dennis Guichard's avatar
Dennis Guichard
Copper Contributor
Jul 28, 2018
Solved

CSV paste not recognising commas

I've just had to reinstall Windows 10 Pro on my PC and reload Office 365. When I now try and paste csv data from an external program into an Excel spreadsheet excel doesn't seem to recognise commas a...
excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 28, 2018

    Hi Dennis,

     

    If you use comma as decimal separator which symbol do yo use for grouping? Other words, what are your settings here

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 28, 2018

Hi Dennis,

 

If you use comma as decimal separator which symbol do yo use for grouping? Other words, what are your settings here

  • DAVID MILLER's avatar
    DAVID MILLER
    Copper Contributor
    Oct 14, 2018

    hi Sergei

    how do i get into the customise format page to change it ?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 15, 2018

      Hi David,

       

      Fastest way is to press Win+R and in command line

      control international

      Enter and in appeared window Additional settings

      • DAVID MILLER's avatar
        DAVID MILLER
        Copper Contributor
        Oct 17, 2018

        THANK YOU ALL OK NOW

  • Dennis Guichard's avatar
    Dennis Guichard
    Copper Contributor
    Jul 28, 2018

    Hi Sergei, thank you for your response which I appreciate.

     

    I have them set as follows:

    I can paste my csv data into Word and it inserts with the correct decimal points, so this seems to be an Excel specific problem that I can't fathom? 

    • Dennis Guichard's avatar
      Dennis Guichard
      Copper Contributor
      Jul 28, 2018

      Hi Sergei... wait... I apologise profusely... I reset those default Windows parameters to match yours... my decimal symbol was a comma rather than a 'full stop'... and Excel seems to be working as I would expect it to now so it must have been something as simple as that which was set up incorrectly by my new Windows installation. What a relief, I can now get back to doing some work today... thank you for deeply and sincerely for your reply which prompted me to get my software functional again. Enjoy your weekend. 

      With thanks and the kindest of regards,

      Dennis

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 28, 2018

        Dennis, you are welcome and have a nice weekend

Resources