formatcurrency puts ( ) for negative numbers

[eddie wang]

formatcurrency function puts ( ) for negative numbers(e.g. (111) ). How
can I display the negative numbers with a minus sign infront like -111.

Thanks.

 

[Aaron Bertrand - MVP]

You'll have to change the registry.

(Curt, changing regional settings for the current user, of course, will only
affect anything until the current user logs off.)

Or, use formatnumber() and a conditional... if it's less than zero, prepend
a -