Saturday, May 5, 2018

What is the difference between Curency and Accounting in MS Excel?

You can easily find out your self.

Here are some pictures for you to review.
I start with a Integer and decimal negative entered in an EXCEL cell as shown.

100000
-500.5

Now, I right click the cells and hit Format Cells... and choose Currency in the category and this is what I see.


ExcelCurrency.png

Now I right click the same cells and hit Format Cells... Choose Accounting from the list and click. This is what I see.


ExcelAccounting.png
If you want to add some color (color coding). You choose, the colored option while you are in Currency as shown.



ExcelCurrency2.png

I am sure you can recreate this in your Excel program.

No comments: