Format Cells SIMPLE question

[Cordury]

First let me start off by posting, I'm an idiot. All I want to do is create a custom format that leaves positive percentages black and formats negative percentages with ()'s and formats the font red.

The current type #,##0.0_%);[Red](#,##0.0%) Is not working for the postive numbers.

Thanks,
Cord

 

[Cordury]

One more thing, will Excel save the format (in XLSTART) for future use ?

 

[KenWright]

#,##0.0%_-;[Red](#,##0.0%)

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[Cordury]

Thank you Ken. Will the type save in the properties box?

 

[KenWright]

Absolutely no clue whatsoever to be honest

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------