Invalid Number Format in Excel 10

  • Thread starter Thread starter hzrabbie
  • Start date Start date
H

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
 
Works fine in MacXL10. Are you sure the worksheet isn't protected?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number displayed as text difficulties 4
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
Excel 2007 VBA - Run-time error 1004 10
macro to change number format of a highlighted range in Excel 2007 4
Format Vlookup column with Text 4
Excel2000: code too slow 2
Regex Pattern 11
Importing .csv with #2000-04-06 10:15:00# date format field 4

Back
Top