| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
currency custom fomula
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 |
|
#2
|
|||
|
|||
|
Hi
try the custom format: $#,##0.00_ ;[Red](-$#,##0.00) -- Regards Frank Kabel Frankfurt, Germany Michele wrote: 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 |
|
#3
|
|||
|
|||
|
One way
$#,##0.00_);[Red](-$#,##0.00) Regards, Peo Sjoblom "Michele" wrote: 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 |
|
#4
|
|||
|
|||
|
thanks that works but without the ( ) around it
"Frank Kabel" wrote: Hi try the custom format: $#,##0.00_ ;[Red](-$#,##0.00) -- Regards Frank Kabel Frankfurt, Germany Michele wrote: 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 |
|
#5
|
|||
|
|||
|
No parenthesis? Use
$#,##0.00_ ;[Red]-$#,##0.00 Regards, Peo Sjoblom "Michele" wrote: thanks that works but without the ( ) around it "Frank Kabel" wrote: Hi try the custom format: $#,##0.00_ ;[Red](-$#,##0.00) -- Regards Frank Kabel Frankfurt, Germany Michele wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
| Add custom Worksheet and Toolbar in shared drive | Excel Discussion (Misc queries) | |||
| Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
| How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel | |||
| Custom Header | Excel Discussion (Misc queries) | |||
Linear Mode
