lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- 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!!
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!!