Sunday, May 02, 2010

How a Web Design Goes Straight to Hell

Lately I've received several requests for web site changes that don't make sense, either for our web site visitors or for us. The latest request reminded me of a comic I read a long time ago. It was a great comic, so I spent some time searching for it. I'm sure I'll want to reference it some day, so this post is to make sure I can easily find it again. And you may get a kick out of it.

Friday, March 26, 2010

converting text to numbers in Excel

I found a helpful trick in Microsoft's Excel help for converting text to numbers in a range of cells. Thought I'd pass it along.
  1. Enter any number in a cell.
  2. Copy it (Ctl-C).
  3. Select the range that you want converted to numbers.
  4. Select the menu options Edit, Paste Special.
  5. Select "multiply" on the pop-up form.
  6. The range you selected should now contain numbers, not text.
It's in Microsoft's help, but who looks there?