Custom Number Format 1

[mkrauss]

Is it possible to create a custom number format so that negative numbers will be displayed in parenthesis on reports? I basically would like the numbers on my reports to look as if the "Accounting" format found in Excel had been used. Currently, all my numbers are formatted as "Standard".

Thanks,

Mike

 

[Remou]

Hi
This is a quote from help for the format property:

First: The format for positive numbers.
Second: The format for negative numbers.
Third: The format for zero values.
Fourth: The format for Null values.

For example, you could use the following custom Currency format:

$#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"

Is this what you mean?

 

[mkrauss]

Exactly what I meant!

Thanks,

Mike