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

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

Resources