Microsoft

ASCII Extended Character Set

 

Typing an ASCII character

In DOS:
Hold down the <Alt> key while typing the decimal number on the keyboard keypad. (Example:  <Alt>178)
 
In Windows for a DOS character:
Hold down <Alt> while typing the decimal on the keyboard keypad. (Example:  <Alt>230)
 
In Windows for a WIN character:
Hold down <Alt> while typing "0" then the decimal number on the keyboard keypad. (Example:  <Alt>0140)

I just had to put something here as I have been buying and returning failed/corrupt USB pens.  In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent.  I use my USB pen as the "My Documents" folder on every computer I use.  It was fine with my 16Gb one but my 32Gb ones have all failed at some point.

I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com (Leather 64Gb@£29.99).  In hindsight, the Ebay one was obviously going to fail (faking the disk size).

I got badgered by my colleagues to splash out and get a worthwhile pen.  Aside from some other failures, I decided to get the bulletproof, waterproof, fireproof, shockproof 32Gb USB Pretec Pen (as advertised by Gadget Show on Five.tv).  Turns out this is an incredibly fragile pen. If files are being written to it and it gets nudged, this will corrupt the pen.  BTW I don't use the "remove device safely" rubbish as my old pen never did and it was fine for over a year.  The default setup in windows XP is that it doesn't need it.

Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof! ...

 This is an issue relating to the Time Server Synchronization error.  Basically you start up windows live messenger and get the following error:

{rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox}

Basically you need to check that the time on your windows clock is accurate or close to real Internet time:
Windows 7:  System Clock is constantly going out of sync

The Issue

People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right date/time.


The Quick Fix

First off, check there aren't any Update for Windows 7 releases at Microsoft's Windows Update

Applies to:
  • Microsoft Windows XP
How?
 I keep having to do this every year as I reghost all my machines (=restore to sorta factory settings), so instead of googling it and going through other websites that work and don't; I thought I might as well post the way I do it:

  1. Open up windows explorer
  2. Go to Tools -> Folder Options
  3. Click on the File Types tab
  4. Scroll down and select (NONE) Folder as file type
  5. Click on Advanced
  6. Click on New...
  7. For the Action type what ever you want the context menu to display, I use Command prompt from here
  8. For the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program)
  9. Click on OK > OK > Close

Notes:
  • Added by default since Microsoft Windows 7

 This is in the case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD.

  1. Insert original CD in the drive
  2. In the CD Drive dialog box, click CANCEL
  3. On the desktop, double-click on MY COMPUTER
  4. Right-click on the CD drive and select OPEN
  5. Go to EDIT > SELECT ALL > EDIT > COPY
  6. PASTE to a temporary folder
  7. Select all the files, right-click on them and select SEND TO > DIRECTCD

 

What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).

My Data:
Account ID,Name,Phone,Record ID
1457102000000135533,Joel,00441234567890,1457102000000165989
1457102000000135566,Stanley,01709123456,1457102000000167543
1457102000000135608,David,00331234567890,1457102000000166795
My Excel:
Account ID	Name	Phone	Record ID
1.4571E+18	Joel	4.41235E+11	1.4571E+18
1.4571E+18	Stanley	1709123456	1.4571E+18
1.4571E+18	David	3.31235E+11	1.4571E+18

How?
Firstly, save the CSV file as text file (*.TXT).

What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).

How?
So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.