Welcome to Andy Rathbone's Web site

Site menu:

I'm one of today's best-selling computer book writers, with more than 15 million books in print.

This Web site keeps you up-to-date on me, my books, and your computers. Each week, I answer a reader's question on-line.

Site search

Popular posts

Categories

Recent Comments

Windows 7 For Dummies

Windows 7 For Dummies

The perfect plain-English guide to the much-anticipated release of Windows 7!

Archive for 'Spreadsheet'

Making a spreadsheet display numbers, not random dates

Q: My wife keeps a spreadsheet for our finances. Now, when she types in an amount (£4492, for example), the computer translates the entry into a random date (30/9/1911, for example). Where has she gone wrong?
A: The solution depends on the brand of spreadsheet she’s using. But it sounds like she’s accidentally formatted that column’s [...]