Invalid Number Format in Excel 10

[hzrabbie]

I want to display "N/C" (meaning "No Charge") to appear when the valu
of a numeric cell is zero.

In Excel 9, this works fine: Range("B20").NumberFormat
"$#,###;($#,###);N\/C"

In Excel 10, this statement causes a run-time error 1004 (Unable to se
property)

I also tried: Range("B20").NumberFormat = "$#,###;($#,###);NC" bu
without success, so it's not the slash that's causing the problem.

Any suggestions?

Thanks

 

[JE McGimpsey]

Works fine in MacXL10. Are you sure the worksheet isn't protected?