I've just spent a week figuring out how to best import German and Spanish bank statements into Excel in America. Some European statements import well, others less so. (In this case Deutsche Bank and Banco Sabadell). As I've noticed in researching the problem that is not uncommon, I decided to...
In every downloaded account spread sheet imported in utf8 (other formats also attempted) I am unable to get any numbers to calculate. Formulas return zero.
Attempted so far
Using regular interfaces to change format to numerical.
Special paste as values.
Special paste multiplying all column by 1...
One of a large number of recently installed updates is corrupting my system.
Late last night Skype stopped working and I could not connect a new Outlook account due to a failing windows common shell DLL. An events check revealed an update barrage shortly prior to the incident. Restoring to a...
I have an account download with unaligned cells. Row numbers 72-75 will have a single date cell, but the transaction description in the next column is divided into two or three rows, the date may be one full height column or two or three. You can see it in the attachment better than I can...
Frequently but not consistently the paste special interface on Excel only provides the choices of Unicode or text This can happen with the same data on the same spread sheet. Skype for Firefox is not installed, Excel has no add-ons and has been tested in Safe Mode. All data is in numeric format...
Cells were cut and paste from the Berlin Sparkasse web site. Using the format option they were then reformatted as numeric general. A simple formula (=A1*$C$1 , where the value of C1 was the conversion factor for Euros to dollars) would not function. The suggested solutions, using the error tab...
Instead of the usual paste special options an interface with a choice of formats appears. I am trying to multiply cells in a column by a constant, which is easily achieved via paste special. I have exhausted the following fixes:
Skype turned off
Skype click to something removed.
Start Excel in...
Having a little trouble setting up a new Lenovo with Windows 8. Aside from the fact that Microsoft has determined that everything I do is on the web and offers a screen full of "apps" (What happened to programs) I can't use with the assumption that I will always be connected (I won't) I cannot...
I am having extremely odd issues with Windows. Use Avast, thought I had a firewall on the router (which appears not to be running..oddly and unfortunately) and windows firewall, a few other precautions. Do very little risky surfing, but did download DriveClone in a moment of desperation.
At...
At about noon today on reboot Windows 7 would not open Word, then would not open other programs. It boots quickly, but once Windows is open it freezes or slows on accessing the start menu or on trying to open any program or access the task manager or Control Panel.
Other symptoms: Non...
We have been found by a Ukranian Spam server/provider of space for spammers named Beyond the Network USA. My mail server uses an RBL but these (satellite) servers are only sporadically identified - surprising considering the extent of their badness reported across the web. (Lots or reports of...
During multiplr Outlook challengesI have set up the same
Outlook exchange account several times, after making a secure copy of the .ost file. the new setups however create a .pst data file an will not recognize the .ost file. Since I need to have the mail left on the server, I believe the ,ost...
After migrating data from a failing drive and "successfully" authenticating Outlook 2010 Trying to access server sent up repeated stand-up-man "Windows Security" credentials popups, with the correct log-in name but false password. Entering correct password and checking "remember password" has no...
I have a desktop based software i do not want to put on a remote server (it may not even be possible). I would like to access the desktop from Ipad. I hear this is possible, but Ihave not yet found the (vpn?) solution. Suggestions would be appreciatrd.
ASUS P8H77-M CSM new with 8GB Ram, 2 (in theory) SeaGate 1TB HD's .
Issues:
1) Del does not bring up bios. Setup only accessible if cmos reset, then via F1.
2) Flash screen freezes
3) If only boot drive on board, long flash screen. Boot to W7 takes about 8 or 9 minutes (really long)
4) Will not...
After a month's absence I returned to a white warning on a blsck screen that the year or so old boot drive (SEAGATE - BARRACUDA 1TB (1000-GB) 7200RPM) was bad, reboot, backup and replace. (not a direct quote).
Chckdsk / Disk Scan run after reboot shows the drive to be in good condition with no...
Have small hope, but thought I'd ask (you all know everything). I need to search in a long code document (transferred to work for simplicity's sake) for the validation of a field requested in a query.
That means searching for a previous instance of the exact term. I notice that there is no more...
I am running Access 2000 and Home Office 2010 on Windows 7. I have been having considerable challenges with merges (for instance changing the data source..there must be a way?)
The merge interface only shows 7 of the twelve records, excluding those recently added.
The file was saved and was not...
After moaning about Windows 7 search for some time I think I have found a solution.
Windows 7 search is an abomination, crashes my machine, gives me a list of hundreds of mp3 files (not necessarily songs) when i search for a file named "music" and can't find idapi32.*** with both hands...
I am fighting Paradox on a new W7Pro installation; The issue is that Paradox has two files which reset the default file locations every time it is shut down. They are pdxregcln.exe and pdxregcln.ini. (Paradox default settings throw all files into the great My documents cloaca. I need a distinct...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.