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 ...

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 ...

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 ...

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 ...

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 ...

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

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...