Custom Format Issue

[RussellNonBrand]

Hey everyone,
Quick question. I have inherited a report for a client who wants to see a plus or minus in front of each value, along with either green or red text color. Problem is I have to produce this report on the client's laptop, and it only has Excel 2003.

Conditional Formatting in '03 will let me change the green or red that's fine.

However, in the regular formatting is there any special way I can have it display a plus sign for a positive value and a dash for a negative value?

Thanks!

[TMS]

Custom: [Green]+#,##0.00;[Red]-#,##0.00;[Blue]#,##0.00

Regards

[RussellNonBrand]

Thanks! Works great!

[TMS]

You're welcome. Thanks for the rep.