Excel 2000 VBA - Removing leading zeroes from negatives
 

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

--
Message posted from http://www.ExcelForum.com

Excel 2000 VBA - Removing leading zeroes from negatives
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


I have a cell with the following value

-0001,000,000

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

($1,000,000)

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

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

Thanks,
Marc


---
Message posted from http://www.ExcelForum.com/