Negative Numbers

M

Matt

Is there a way to format negative numbers to be displayed as (##) instead of
-##? Do I need to set the format in VB or can I easily set it in the column
format menu box?

Thanks,
Matt
 
D

Douglas J. Steele

You can set a custom format for the field.

For numeric fields, you have the option of specifying up to 4 separate
formats, using semicolons (;) as the list separator. Each section contains
the format specification for a different type of number.

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

In your case, you'd want something like #;(#) as the format.
 
Top