Calculation needing to show negative figures

[OTWarrior]

I have (complicated) series of calculation boxes which draw their data from
text form fields and drop down form fields, and the final resulting
calculation is the overall cost.
eg:

(text1 * dropdown1) = calc1

calc2 = (calc1 * text2)

calc1 is the hours result, calc2 is the cost result.
calc2 is actually made using the autosun button, and changing the formula
(otherwise it gets confused with calculating using another calculation)

I have a situation where the figure can be a negative (hours off for
example) which shows this figure fine. (-5 hours). the problem lies with the
cost which shows the figure in a different format [exact example below].

(£50.00)

whereas it should show
£-50.00
or
-£50.00

How do I change this (if possible)?

 

[Stefan Blom]

To the field code, add a numeric picture switch to specify the format of
positive, negative, and zero results, respectively. For example:

\# "£#;£-#;0"

The code means: for positive results, display currency symbol and then
the number (or a space); for negative, display currency symbol, minus
sign, and number; for zero results, display only a zero.

--
Stefan Blom
Microsoft Word MVP


in message
news[email protected]...