Cell format - Negative numbers

[Damodar]

Hi,

I need to get the negative values (-$150,000.00) to be displayed as (($150,000.00). Hyphen should be replaced as brackets. This should only happen to negative values. I need A3 should change automatically if we enter -500 or so.

I have data like this.

Cell - data
A1 : $400,000.00
A2 : $2,000.00
A3 : - $150,000.00

Please let me know if any questions.

 

[Debraj]

Try custom Format...

 

[Damodar]

Is it possible to replace INR symbol to $?

 

[NARAYANK991]

Hi Damodar ,

Try this format :

[$INR ]#,##0.00_);[$INR ](#,##0.00)

Narayan

 

[webmax]

How to get in red colour with above formula.

 

[Debraj]

[Blue][$INR ]#,##0.00_);[Red][$INR ](#,##0.00)

 

[Abhijeet R. Joshi]

@Deb & Narayan,
Can you help us know how to get these worded? So that we can customize it as per our requirement?
like its [color][Currency]??

 

[NARAYANK991]

Hi Abhijeet ,

This link gives some useful information :

http://www.databison.com/custom-format-in-excel-how-to-format-numbers-and-text/

Narayan

 

[Abhijeet R. Joshi]

Thanks Narayan, my office system does not allow me to open that link but I am quite sure that it will be of great use.....

Will surely open the link once I reach home....

 

[SirJB7]

Hi, Abhijeet R. Joshi!
No need to go further, within the built-in help of your installed Excel version you'll find anything about formatting numbers. The following is from my Spanish version, for your English one just replace "formato celda" by "format cell":

If thru the cyberspace, check this official site:
https://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx
Regards!

 

[Abhijeet R. Joshi]

Thanks SirJB7, as I had missed to open Narayan's link yesterday at home as well....
The link is great and so is the post about built-in help...