| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
negative currency with () and -
Hello, Is there any way to get excel to return a number that looks like this? (-$123.00) I am able to get the cell to show -$123.00 and ($123.00) but i cant get the other one. I am doing a sheet that shows year to date information with a separate columm with a goal. So the cell in question must show if either i am under the goal amount or over the goal ammount. It is working just fine but I am not able to have it return a value like (-$123.00) Is this possible? You help is greatly appreciated. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=379437 |
|
#2
|
|||
|
|||
|
Use a custom number format: 0_);(-0)
"joeldsmt" wrote: Hello, Is there any way to get excel to return a number that looks like this? (-$123.00) I am able to get the cell to show -$123.00 and ($123.00) but i cant get the other one. I am doing a sheet that shows year to date information with a separate columm with a goal. So the cell in question must show if either i am under the goal amount or over the goal ammount. It is working just fine but I am not able to have it return a value like (-$123.00) Is this possible? You help is greatly appreciated. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=379437 |
|
#3
|
|||
|
|||
|
THAT WORKED. Much appreciated. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=379437 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating growth with negative numbers | Excel Worksheet Functions | |||
| Currency Style button | Excel Discussion (Misc queries) | |||
| How do i enter negative times in Excel & how can they be 'fiddled. | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Linear Mode
