This is a quick article on how to convert some cells in Microsoft Excel to number values...
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was?
I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the Philippine peso by the conversion rate, it returns #VALUE!
The problem is that I have a column which includes the currency symbol as per the following image:
- Apple iOS 7
- Apple iTunes 18.104.22.168
- Microsoft Windows 7 Professional
Just so many articles out there that did not help me. This article is how I finally did mine.
I had paid for some apps on my old phone and realized that if I didn't do a "restore", then I would have to install and pay for them all again. My purchased music was in the cloud so those could be re-downloaded on to the new phone (not fun).
The Apple documentation iOS: Transferring information from your current iPhone, iPad, or iPod touch to a new device was as useful as a Microsoft KnowledgeBase article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio).
Note that the restore can be done when the new phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID).
This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top.
The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday).
See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday:
- Microsoft Windows 7 Enterprise
- User with Local Administrator Privileges (required for setup)
Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS), require elevated or administator rights/privileges when run. This is so that these programs can write back and forth to our C drive. If we don't run them as local administrators on the workstation, they error incessantly and never manage to do what you want them to do.
I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this may not be a problem but this is intended for those in an office environment and we get prompted to login (with the same account as we're currently logged-in with???) instead of being able to just click on "Yes".
The gist is that we're going to create a scheduled task (that won't be scheduled) and a shortcut to that task:
So another year gone and our workstations running Windows 7 are somewhat lagging when opening too many apps. The recent release of Windows 8 has led to a review of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System:
Proposed for January 2013 (5 suppliers)
|Processor||Intel Core i3 3220 Dual Core CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy Bridge, 55W, Intel HD Graphics 2500, Advanced Vector Extensions) - Intel||£88.50|
|Motherboard||AsRock H61M-DGS Motherboard (Socket 1155, Intel H61, DDR3, 4 x S-ATA 300, Micro ATX, PCI Express 3.0, AsRock XFast USB, AsRock Instant Boot) - ASrock||£37.58|
|Hard Drive||Western Digital Caviar Blue 160 GB (7200 rpm) SATA 8 MB 3.5 inch Hard Drive (Internal) - Western Digital||£24.95|
|Memory||Corsair CMX4GX3M1A1333C9 XMS3 Desktop Memory 4GB - Corsair||£20.05|
|Optical Drive||Sony AD-5280S-0B DVD±RW 24x SATA Drive with Dust Protected Enclosure and Emergency Eject - Sony||£17.77|
|Other||2 X Serial ATA Sata Hard Drive Data Cable Lead - Unbranded||£0.90|
Confirmed for January 2013 (2 suppliers):