Windows 10: How to change number format in Windows 10 negative numbers in parentheses

Hello. I would like to change the number format in Windows 10. I read the following pages below from answers to other posts but they are not helpful. The number format setting is not with Time & Date anymore. I cannot use the normal 'currency' or 'accounting' format in excel to display negative numbers in parentheses. Yes, I can use the 'custom' format, but I need to enter a certain template all the time if I am changing from one currency to another. Thanks a lot!



https://support.microsoft.com/en-gb...ce7-92db-cc9eebc5ffa0?ui=en-us&rs=en-gb&ad=gb

https://support.microsoft.com/en-us...ta-types-edf41006-f6e2-4360-bc1b-30e9e8a54989

:)

 

Usage of 'Negative number format' in regional setting

Would like to know the usage of 'Negative number format' in regional setting. A user change this to "()" and some program crash.

There is another setting 'Negative number format' which make the setting more ambiguous.

 

Excel default number formatting not follow Windows 10 Region settings

Dear All,

I use Office 365 on Windows 10 1809. I would like to show negative number in Excel with parentheses by following article below,

https://support.office.com/en-us/ar...in-Excel-682A1CC5-701A-4CE7-92DB-CC9EEBC5FFA0

This used to work in an older combination of Windows+Office. But now, only date/time format in Excel is influenced by Control Panel settings. Does anyone have a fix/workaround?

Rgds.

Martin

 

Arabic Numbers format - issue if the number followed by any character

Hi,



Thank you for writing to Microsoft Community Forums.



By default, the Currency format is set as English numbers. However, you can change the Currency format to Arabic numbers using the drop downs. Please follow the steps mentioned below:

1. Press Windows key + R, to open
   Run dialog box.
   
2. Type control and click on
   OK.
   
3. Click on Region.
   
4. Click on Additional settings and click on
   Currency tab.
   
5. Now, click on the drop down for Positive currency format and change it as per your requirement. Follow the same for
   Negative currency format.
   
6. Once done, click on OK(Twice).
   

Let us know the results, we will be glad to help you further.



Regards,

Nikhar Khare

Microsoft Community - Moderator