Forum Discussion
Excel conversion issue? - comma separated vs column separated
I have a .csv file that is comma separated between columns. When I open the file in Excel, the data appears as expected, separated in columns. However, when a coworker opens the same file in Exce...
Let your coworker check File > Options > Advanced in Excel.
Has the check box 'Use system separators' been cleared and has 'Decimal separator' been set to comma?
HansVogelaar thank you for the info! That seems to be the issue. When I reached out to my coworker the next day, she checked her decimal separator setting and it was set to a 'comma' instead of a 'decimal'. Thank you!!