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

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

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

In article ,
hzrabbie wrote:

I want to display "N/C" (meaning "No Charge") to appear when the value
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 set
property)

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

Any suggestions?

Thanks!