Home |
Search |
Today's Posts |
#1
|
|||
|
|||
India comma style in negative but in brackets
The below formula works in Indian format.
[=10000000]#,##0,_;##\,#,#\,##,\,##0;[=100000]##,###,#\,##,##0;##,##0 But If I want to put amount in negatives i.e. in brackets like (1,50,000) so what is the method. Can you please help me out. -- With warm regards, Shri |
#2
|
|||
|
|||
Here's a Custom Format from Sweden: [$€-2] # ##0,00_);[Red]([$€-2] # ##0,00) HTH Ola Sandström Note: Microsoft UK site - there is probably one for India http://support.microsoft.com/?scid=k...d=1743&sid=340 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380287 |
#3
|
|||
|
|||
This would not be solving the problems. I need the figures is in brackets
like (1,50,000). Can you please help the same. -- With warm regards, Shri "olasa" wrote: Here's a Custom Format from Sweden: [$‚¬-2] # ##0,00_);[Red]([$‚¬-2] # ##0,00) HTH Ola Sandström Note: Microsoft UK site - there is probably one for India http://support.microsoft.com/?scid=k...d=1743&sid=340 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380287 |
#4
|
|||
|
|||
Try:
##\,##\,##\,##0;[Red](##\,##\,##\,##0) Mangesh "shrinivas" wrote in message ... This would not be solving the problems. I need the figures is in brackets like (1,50,000). Can you please help the same. -- With warm regards, Shri "olasa" wrote: Here's a Custom Format from Sweden: [$?-2] # ##0,00_);[Red]([$?-2] # ##0,00) HTH Ola Sandström Note: Microsoft UK site - there is probably one for India http://support.microsoft.com/?scid=k...d=1743&sid=340 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380287 |
#5
|
|||
|
|||
check this thread:
http://groups-beta.google.com/group/...ksheet.functio ns/browse_thread/thread/d639c3f67cc5a5b2/f58c5e67139c1fd8?q=custom+format+in dia&rnum=3&hl=en#f58c5e67139c1fd8 Mangesh "Mangesh Yadav" wrote in message ... Try: ##\,##\,##\,##0;[Red](##\,##\,##\,##0) Mangesh "shrinivas" wrote in message ... This would not be solving the problems. I need the figures is in brackets like (1,50,000). Can you please help the same. -- With warm regards, Shri "olasa" wrote: Here's a Custom Format from Sweden: [$?-2] # ##0,00_);[Red]([$?-2] # ##0,00) HTH Ola Sandström Note: Microsoft UK site - there is probably one for India http://support.microsoft.com/?scid=k...d=1743&sid=340 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380287 |
#6
|
|||
|
|||
and yet another:
http://groups-beta.google.com/group/...ksheet.functio ns/browse_thread/thread/8eae769ceeb4e682/815a1ca9b4f6d783?q=custom+format+in dia&rnum=1&hl=en#815a1ca9b4f6d783 Mangesh "Mangesh Yadav" wrote in message ... Try: ##\,##\,##\,##0;[Red](##\,##\,##\,##0) Mangesh "shrinivas" wrote in message ... This would not be solving the problems. I need the figures is in brackets like (1,50,000). Can you please help the same. -- With warm regards, Shri "olasa" wrote: Here's a Custom Format from Sweden: [$?-2] # ##0,00_);[Red]([$?-2] # ##0,00) HTH Ola Sandström Note: Microsoft UK site - there is probably one for India http://support.microsoft.com/?scid=k...d=1743&sid=340 -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=380287 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cannot get Excel to put negative amounts in brackets. Help ! | Excel Worksheet Functions | |||
How do I get brackets around negative numbers? | Excel Discussion (Misc queries) | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
How do I get negative numbers to show as brackets? | Excel Discussion (Misc queries) |