ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I change the default 'comma' format. Eg paranthesis inste. (https://www.excelbanter.com/excel-discussion-misc-queries/1210-how-can-i-change-default-comma-format-eg-paranthesis-inste.html)

Duncan

How can I change the default 'comma' format. Eg paranthesis inste.
 
When I installed MS Office 2003, the default format for the ',' style has
negative sign instead of parenthesis. How can I change the default such that
every new workbook has the change included?

Gord Dibben

Duncan

FormatStyleStyle Name "Comma"

Select it and click on "Modify" button.

Choose a format you like from the Number Tab.

Gord Dibben Excel MVP

On Fri, 3 Dec 2004 16:29:02 -0800, Duncan
wrote:

When I installed MS Office 2003, the default format for the ',' style has
negative sign instead of parenthesis. How can I change the default such that
every new workbook has the change included?




All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com