Setting Excel Number format

[drkestrel]

Anyone know what's wrong with the following code??

xlSheet.Range("C5").NumberFormat = "Text"

where xlSheet is an Microsoft Excel Worksheet object

setting other Range object to things like "dd mmm yyyy" does work!

running the above code, however, generates error in 'can't set numberformat to range object!!

 

[dsi]

If you want to format the cell as a Text field;

.NumberFormat = "@"