Decimal separator after CSV import
Hi, I need some help, please. I'm trying to import a csv file. The problem is that numbers are written with comma decimal separator, but my PC is working with dots as decimal separator. In the previous Excel versions, there was the possibility to convert them during the import wizard. Unfortunately, I'm not able to find the same option in the new import wizard (Power Query). Thanks for all your answers Luca
Excel Language Options
Hello everyone, Hopefully someone might have an answer for my situation. Any feedback or suggestions are welcome. I work as a designer for a company that produces document books within a variety of languages, including english, french, greek, Russian, Arabic and Hebrew. Currently, I use a variety of programs and files to create translation documents for each other the languages. What I am trying to do is create one Excel document with all of my languages and translations and export that as a CSV to import into Indesign with Data Merge. My current problem is that I can't seem to change between writing styles for different languages, such as from left-to-right typing to right-to-left typing. Any advice or potentially an easier way to do what I am trying to do is appreciated. Thank you.
CSV formatting
Good evening. I have just reinstalled Windows 10 Home in my notebook and installed O365 as well. However, now my CSV files I used to download and use without issues now do not work anymore - it is all without format and impossible for me to work - does anyone know what might be the issue? I open the CSV file using Excel and it is not usable. Below the example of what I see in the CSV file in Excel and my regional formatting already has decimal with comma. What should I do?? Tks, André Thanks and regards, André
Excel Import 32 bit vs 64 bit
I currently use the 32 bit excel, which I believe only allows use of 2gb or ram. This is extremely frustrating when working in large spreadsheets. I've requested from my IT department an upgrade to 64 bit. Their response is that our accounting system does not support the 64 bit. My question is how would a separate system be effected by the use of 64 bit vs 32 bit? I understand an add-in needing a certain excel version but would exporting reports from our accounting system to csv. or xls. be effected by 32 vs 64 bit excel? Wouldn't I be able to export a report to csv. then open in excel no matter the version?What's the difference between "CSV-File (.csv)" and "Microsoft Excel-CSV-File (.csv)"?
Hi, I have noticed that a .csv file opens differently on my two machines. On machine A) the opened file displays everything in separate columns: On machine B) the opened file displays everything in the same column: I can't figure out why that is. The Windows and Office versions on both machines are identical. Windows: 1709 (Build 16299.431) Office: 1802 (Build 9029.2253 CTR) I noticed that the file icon is different on both machines. Machine A): Machine B): Moreover, I file type (Dateityp) seems to be different (please don't mind the German): Machine A) says "CSV-Datei": Machine B) says "Microsoft Excel-CSV-Datei": Furthermore, I opened the file in Excel Online and it opens like on Machine B). One more thing I did is use PowerShell Get-Service | Export-Csv "C:\users\[xxx]". I would expect each property to show in it's own column. It does that on machine A) but not on B). I have attached the file for you to test it. Ideally I would like the file to opened on every machine as it does on A). Thanks in advance for your help.
