Those Pesky New Digits of the New Year
Now that it is a new year, sometimes we forget to date things with the correct year. Use conditional formatting to alert yourself of a wrong year entered in excel.
Working With Time in Excel
When entering time in the cell don’t forget it starts with hours. Using a 24 hour clock is best, no need to type “am or pm”. Once you enter your time you can format the cell as needed and the formula will work. If you are only adding minutes and seconds, you still need the […]
Opening Old Files
Q: How can I open this [file type] file? When I click it it will not open. I often get calls from friends and colleagues to help them open a file that was either sent to them via email or something that is in their archives that they need to revisit. The answer is short […]
Have Fun with Tab
Hold down the shift key while tabbing to go backwards. Hold down the ctrl key to tab in a table (MS Word).
#099 Think Ahead
Q: Why the the leading zeros?
A: I’m Thinking ahead.
When working with numbers with text, adding leading zeros to a number keeps the alpha sort incorrect order.
| File | DLs | |
|---|---|---|
| 1. | Dream House Excel Data | 143 |
Pauline’s Letters
Subscribe
Artwork Credit
Photos for Sale
Recent Posts
My Projects
My Gravitar
