I use a worksheet for each month of the year. The lefthand column of the sheet gives the date. You don't have to type 1-Jan, 2-Jan, 3-Jan, etc for the whole month. Excel can interpret a positive integer as a date. Here's how it works.
1 = January 1, 1900
2 = January 2, 1900
. . .
40,179 = January 1, 2010
So try this: Put "40179" in cell A5. Right-click A5 and choose "Format cells." Select "Date" from the Category box and choose the Type on the right. You'll see a preview in the Sample window.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfHL7Kk5zU9ePdCwWY0N1DXJ5zB8Mttf5ZvK2ufR58PggeHIejiJDSqRnw0Xx7kRudcnxsQDLV8uSOaWDmI0Jv5H4uWj0GsQF0Df7joowicz-mZam65xj_mqASZ1Ddq0JuezkeHg/s400/moz-screenshot-3.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOCKvCH7fUldUuxBFT6vNy_ZARl5sOnfOuyvc8z8tbIYAkex_r9ytWCLkJGQo7CjRjWLxRcpvUNrbqafS9lLdsUz9wl8SreOZYteOYGoXdb5ZzOIwTCVzcQUxUtQ1IOuEx2ms-KQ/s400/moz-screenshot-4.png)
You can redo this for every month (February 1, 2010 = 40,210), or I suppose you could do the whole year in one sheet.
The format for most cells in the sheet (everything east of column A and south of row 4) will be Currency. I prefer the format that shows negative numbers in red with parentheses. When the cells are set up like this, Excel will automatically interpret an entry like "4.1" as $4.10 and -38.5 as ($38.50). High visual contrast and a minimum number of keystrokes. That's what I like.
No comments:
Post a Comment