Help with macro that moves negative sign

[Parra]

I have a macro that formats numbers with the negative sign on its right and moves it to the left.

The macro works fine, but now I need the number to look like this: -750.56
Currently the macro is putting the number in brackets like this: (750.56)

How could I change the code below so that the number looks like this: -750.56

.NumberFormat = "#,##0.00_);[Red](#,##0.00)"

Thanks

 

[eliW]

On 2002-08-29 10:28, Parra wrote:
I have a macro that formats numbers with the negative sign on its right and moves it to the left.

The macro works fine, but now I need the number to look like this: -750.56
Currently the macro is putting the number in brackets like this: (750.56)

How could I change the code below so that the number looks like this: -750.56

.NumberFormat = "#,##0.00_);[Red](#,##0.00)"

Thanks

Hi Parra,

Try:

.NumberFormat = "#,##0.00_); -#,##0.00"

Eli

 

[Parra]

Thanks but Never Mind, I figured out that it was a template that I was using that was causing my problem not the macro.

Please help someone else.

Thanks