Excel isn't really unhappy. It's just that the optional error checking
feature is pointing out some possible inconsistency. The green markers do
no harm but if you want to turn them off it can be done on the Formulas tab
of Excel Options (Excel 2007 and 2010).


"Derick" wrote in message
...
Hi

I am using C# to try and format a range in Excel as numbers. When
doing this, I get the green error arrow in the corner to ask me if I
want to format the column as a number.

I used the code below to format the data:

Excel.Range Data = currentSheet.get_Range("K2:K10", Type.Missing);
Data.NumberFormat = "0.00";

How do I convert the range to numbers so that excel is happy?

Thanks
Derick