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.
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 […]
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.