Warning: This post deal with editing the registry. If you don’t know what that is stop right here & ask someone else to help you. Using the registry editor incorrectly can cause serious problems that may require you to reinstall Windows. Use the registry editor at your own risk
The power supply in one of our computers died. It was an old Dell Optiplex GX270. I’ve had problems in the past with that model’s power supply so I didn’t even want to bother ordering a new one.
I had plenty of spare computers that I could just move the hard drive to. So I take the hard drive out of the GX270 & put it in a GX260 & turn it on. I get a BSOD with a STOP: 0x0000007B (0xF894F528,0xC0000034,0x00000000,0x00000000). Apparently the hard drive controllers are different enought that Windows didn’t like it.
Doing a little tube searching I came across KB314802. It gives you a nice little reg file to import into the registry. I didn’t need to copy the files it mentions because they were already there. Using BartPE I was able to import the registry settings. Rebooted one more time & Windows came right up! Just had to install the chipset, audio, & video driver then all was good again.
This link has the notes on using BartPE to import the reg file.
This is my little way of changing the way a phone number is displayed in a cell not using number formating (i.e. General).
Cell A1 contain 5555555555. I want it to display as (555) 555-5555. So in B1 I enter the following formula:
Right click B1 & select copy. Right click A1 & select Paste Special. Select Values & click OK. Now delete cell B1.