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 cell to display its conents as a date rather than currency. To fix this problem in Microsoft Excel, for example, your wife needs to right-click anywhere inside the problematic cell and choose “Format Cells” from the pop-up menu.
The Format Cells window appears, letting her choose how Excel should display that cell’s contents: General, Number, Currency, Accounting, Date, etc. In your wife’s case, choosing “Currency” rather than “Date” should fix the problem. In fact, all her current nonsensical dates should then revert to the currency amount she originally entered.