Using conditional formatting to alert yourself of wrong year. Now that it is January 2018, sometimes we forget to date things with the correct year, but it usually only happens a couple times before the new digits are embraced. The brain freeze I have every year happens when I’m entering data in Excel. Much of […]
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 adding minutes and seconds, you still need the leading […]
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 […]
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.