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.
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.
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
-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:
Post a Comment