currency custom fomula

M

Michele

i need to get my negative figures to show somthing like this
automaticly { -$1,234.10 } in red. i know you can get the negative to show
but that is in black, and you can get it to show in red but that has no
negative sign in front of it. can anyone help
 
M

Michele

thanks that works but without the ( ) around it

Frank Kabel said:
Hi
try the custom format:
$#,##0.00_ ;[Red](-$#,##0.00)

--
Regards
Frank Kabel
Frankfurt, Germany
i need to get my negative figures to show somthing like this
automaticly { -$1,234.10 } in red. i know you can get the negative
to show but that is in black, and you can get it to show in red but
that has no negative sign in front of it. can anyone help
Click to expand...
Click to expand...
 
P

Peo Sjoblom

No parenthesis? Use

$#,##0.00_ ;[Red]-$#,##0.00

Regards,

Peo Sjoblom

Michele said:
thanks that works but without the ( ) around it

Frank Kabel said:
Hi
try the custom format:
$#,##0.00_ ;[Red](-$#,##0.00)

--
Regards
Frank Kabel
Frankfurt, Germany
i need to get my negative figures to show somthing like this
automaticly { -$1,234.10 } in red. i know you can get the negative
to show but that is in black, and you can get it to show in red but
that has no negative sign in front of it. can anyone help
Click to expand...
Click to expand...
Click to expand...
 
Top