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

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

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