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
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

Resources