accounting vs currency number formatting

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,805
Office Version
  1. 2016
Platform
  1. Windows
Hi
I was reading one of Mike Girvin's document and he said the following:
++
Accounting Number Format:
Fixed dollar sign (left edge of cell).
Negatives are in parenthesis.
Zeros are dashes.
Decimals always line up.


Currency:
Floating dollar sign.
You choose how to show negatives.
Zeros are zeros.
Decimals usually line up.
+++

I formatted 2 cells (General-->) one as currency and one as accounting. in Accounting cell, why I type -100, excel will not insert Parenthesis!!
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
It will depend on how your default formats are set in Regional options in Control Panel in Windows.
 
Upvote 0
Thanks for your reply. I went to control panel-->region-->more settings. and I changed the negative number from -1.1 to (1.1) then reboot and then formatted the cell to accounting and to currency and tried to use -100 but I got -$100 in both cases, again no parenthesis. Thank you again.
 
Upvote 0
you can make a custom number format but i dont know how to change the default accounting format to have parenthesis. i feel like mike was wrong when he said accounting is meant to have negatives in parenthesis or maybe it's for an old excel version or something

for a custom number format you can use
_-$* #,##0.00_-;-$* (#,##0.00)_-;_-$* "-"??_-;_-@_-
that will display -100 as -$(100.00)
if you dont want the minus sign and just have parenthesis for negatives you can use
_-$* #,##0.00_-;$* (#,##0.00)_-;_-$* "-"??_-;_-@_-
that will display -100 as $(100.00)
 
Upvote 0
Thanks for your reply. I went to control panel-->region-->more settings. and I changed the negative number from -1.1 to (1.1)

Did you change the negative format on the Currency tab too?
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top