problem showing Brackets around negative numbers (formatting)

[KalilMe]

Hello,
I am trying to showing Brackets around negative numbers by using cells formatting> number or custom , but it doesn't show anything , the number keeps without show bracket and red color , also I change Control Panel and click on "Change date, time or number formats" > Additional Settings > under Numbers tab in front of Negative numbers, unfortunatly doesn't work !
what's my bad ,guys?!!

 

[etaf]

try
Format > Number
choose
(1234.10)
that should put brackets around negative numbers
which is custom format
0.00_);(0.00)

Book1
	A
1	(12.00)
2	(12.12)
3	(1.00)
Sheet1

 

[KalilMe]

doesn't work at all !!

 

[etaf]

what else is going on with the spreadsheet ? Macros of some description

What happens when you use the formating ?

maybe you need to share the actual spreadsheet -
then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.

 

[awoohaw]

What do you call a bracket?
in the US: ( ) are parenthesis, [ ] are brackets, and { } are braces (or curly brackets)?

 

[awoohaw]

what does this custom format code do:
#,##0.00; [Red](#,##0.00);0.00 ?

 

[KalilMe]

in the US: ( ) are parenthesis

yes this is what I want based on US in my laptop , but in my laptop the language is arabic
so when I change from US to arabic or arabic to US.

#,###.00; [Red](#,###.00);0.00 ?

this will show by arabic not like you and I tested all of options in custom without hange any thing!

 

[awoohaw]

have you tried using all the standard arabic words and symbols?
is the arabic version of this US [ ] this: { }?
Is the arabic version of this US ( ) this: [ ]?
Can you use the arabic word for 'red'?
Are your separators commas (,) or semicolons (; - as in US)?

Also, here is a microsoft help on arabic number formatting. The last comment is something I would not have though. Have you checked out the font you are using?
The title is: excel-help-for-arabic-numeric (I don't know why is says "redirecting").

Redirecting

 

[KalilMe]

have you tried using all the standard arabic words and symbols?

yes

Is the arabic version of this US ( ) this: [ ]?

based on picture should be ( )

Can you use the arabic word for 'red'?

I did it as in post#7

semicolons (; - as in US)?

yes I use this
you can see the picture what I use bracket , semicolon.

 

[awoohaw]

wow. that is odd. What did changing your fonts do?