Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

Both the Currency and Accounting number formats in Excel are used to display monetary values, including the symbol for the chosen currency. However, in this article, I'll explain their subtle ...

How to Format Fractions to Percentages in Excel. The cells in a Microsoft Excel spreadsheet can hold various types of numerical data, including fractions and percentages.

Helen Bradley demonstrates Excel formatting tricks that will help you when things don't work as planned. Learn her methods now.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

Pro Tip: To open formatting options, just select the cell (s) you want to format and press Ctrl-1 (Mac: Command-1). This actually works for anything in Excel: charts elements, images, etc.

Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for clean spreadsheets ...

Improve the appearance and usability of your Excel worksheets with these simple format options.

Formatting using color is such a basic function of Excel that if, after all of the above, you still find that the color options aren’t working, I can only conclude that there must be something ...