Excel Custom Time Formatting

excel formatting how to

How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once there, choose the “Custom” option from the left hand side. Under the word “Type” you’ll be typing in your custom number format. How to Type the Format Customizing time works a lot like customizing dates. However Excel rolls over the clock after 23 hours, so we’ll need to circumvent that. Let’s start with the basic characters. Formatting Characters Hours, Minutes, Seconds Put

Continue Reading

Excel Custom Date Formatting

Most of us at some point have tried to find a particular number format, but we weren’t able to find one that satisfies our needs. There will be another blog to follow this one that specifically deals with time, this one is just about dates. How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once there, choose the “Custom” option from the left hand side. Under the word “Type” you’ll be typing in

Continue Reading

Excel’s Advanced Error Codes – “Why isn’t this working?!”

We’ve all seen Microsoft Excel error codes, and you’ve probably already figured what some of them mean. But when we get into more advanced Excel usage, the error codes we encounter can still be vexing. Understanding the following error codes will promote you to Excel’s Power User status! Excel TIP: Use the Formula tab’s Formula auditing tools to track error issues. We’re going to be using some of them here. #N/A Excel is saying “That lookup value isn’t valid” This usually happens

Continue Reading

Excel Custom Number Formatting Basics

Most of us at some point have tried to find a particular number format in Microsoft Excel , but we weren’t able to find one that satisfies our needs. We will have  other blogs to follow, which will cover date and time, and positive and negative numbers, but for now we’re just going to cover the easiest, fastest ways to customize a number format. How-To In order to create a custom number format, you’ll need to access the Format Cells window. Once

Continue Reading

Roadrunner’s Guide to Excel

The list of shortcuts below are the shortcuts I show to my students. Per a student’s recent suggestion I decided to compile them all into one document. If you’ve been in my class, then welcome back, these are for you! If you haven’t been in my class before, you’ll get plenty of use out of these. **You can scroll to the bottom of this blog to see tutorials on how to use each keyboard shortcut. Moving around Navigate to end

Continue Reading

Sliding Sidebar

Archives