Cyjer

Thank you both for the help! It turned out that I needed to go into the National settings for Windows and change the decimal separator for the whole damn OS in both numbers AND currency! Changing it in Excel wasn't enough. Brilliant thinking Microsoft. But now it formats correctly and I can divide the CSV into correct column by using the "text-to-columns" and removing comma. Again, big thanks for helping me figure it out.

Thanks, but my wife really needs the multiple folding thingy apparently.

Think I found the issue, but I've no idea on how to solve it. In Sweden we use comma in our decimals, like 8,5. I saw in the video that you have dots, like 8.5 Meaning that when I generate a comma separated file, it not only uses comma to separate the values, it also uses comma in the decimals. I've tried using Paint.net in English but that didn't solve anything, possible because my OS is in Swedish? It automatically formats the decimals with comma? I'm just guessing here, I'm not a programmer. Oh, and if possible I'd rather avoid reinstalling my Excel, it's a beat-up old version (but all I got) and I'm not entirely sure it will install again on Win10. And I've already tried using other programs like Open Office and WPS (WPS came only in English btw). PS. Why would I ever use cut and paste in this? The after pic is just after using "text-to-columns"

Hi, I've been helping my wife to get this working properly and it was no problem getting the plugin installed and working. But I just can't get the formatting right in the CSV. I've tried using "text to columns" in Excel but getting rid of the commas is just screwing with the decimals and removing spaces only shifts things around making each document 15-20 min work to get to a workable state. Is there a quick easy way to get the nice fomatting Heather gets in her video? Where everything is where it should be from the start?