CHANGING DEFAULT FORMAT OPTIONS

Rose_Nomed

New Member
Joined
Jul 22, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
I have tried searching for this but have been unable to find an answer. Is it possible to change the default cell format options for cells in 2016 Excel?

Current: When selecting Number from the Home tab formatting options, the cell is shown as a number with no commas and no special formatting of negative numbers. ie: 31557.40 and -31557.40

Preferred: When selecting Number from the Home tab formatting options, the cell results in a number including commas and negative numbers are shown in parenthesis. ie: 31,557.40 and (31,557.40).

I know there are Currency and Accounting formats but other than opening the Format Cells window there is no quick/easy way to format numbers to include the commas and format negatives with parenthesis without including a $ sign.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Rose_Nomed

New Member
Joined
Jul 22, 2020
Messages
2
Office Version
  1. 2016
Platform
  1. Windows
Thanks for your reply! The only issue with this is that my spreadsheets/workbooks often contain amounts and text and the fields which include amounts is ever changing.
 

Forum statistics

Threads
1,136,792
Messages
5,677,761
Members
419,718
Latest member
ALWP

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
Top