Excel 2000 VBA - Removing leading zeroes from negatives

[sub_pop]

I have a cell with the following value

-0001,000,000

When I format it as currency, it keeps diplaying just as above. I wan
it to display as

($1,000,000)

Which is achived as soon as I apply the correct formatting and remov
the leading zeroes

I can set the formatting fine in a macro, but I am not sure how to ge
rid of the leading zeroes. Any help is appreciated.

Thanks,
Mar

 

[Frank Kabel]

Hi
how have you inserted this value (imported from a different source?)