The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number. But the accounting format has a few differences that make ...

Learn how to suppress or hide zero values in an Excel sheet using one of these quick and easy methods. If you want to hide or suppress zero values in a spreadsheet, Excel offers three easy ways to get ...

Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically pleasing and easier to follow. You can use one of ...

Have you tried to enter a fraction into your Excel sheet, but when you press enter, it turns into a serial, whole, or decimal number, and you have no clue what to do? In Microsoft Excel, you can ...

Fractions are enough to make you cry if you’re not a math whiz, but Microsoft Excel handles them very well. In fourth-grade math, you learned fraction basics: Fractions are a numerical representation ...

Excel is a very handy tool for working with data. It has many built-in features, like conditional formatting, which helps you to format and highlight data based on certain rules. The rules can be ...

If you want to use a date format according to how another language displays dates, choose the language in Locale (location).

Excel responds to certain letter and number entries with automatic formatting. This makes sense in most cases, but sometimes it can be very annoying, as the user then has to switch back to the desired ...

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...