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 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?
Microsoft Excel Web Query 404 Error When Importing From Web
Hello all, I am in desperate need of help with this issue. I am trying to import a web query from DoubleClick Search into Excel via the Web option. Every time I grab the URL, input it into the address bar and hit go I get an error "This Website Declined to Show This Web page HTTP 403". Screenshot attached. Please any advice would help.