Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell type
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell type
Derick
Try Range("K2:K10").Select Selction.NumberFormat= "0.00" HTH Mick. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell type
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell type
Vacuum Sealed has brought this to us :
Derick Try Range("K2:K10").Select Selction.NumberFormat= "0.00" HTH Mick. Mick, Since NumberFormat is a read/write property of the Range object, there is no need to select it. (Unecessary selecting slows down code performance) Range("K2:K10").NumberFormat = "0.00" -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to change the background of a cell if I type a certain wor | Excel Worksheet Functions | |||
How do you change the data type of a cell using VBA? | New Users to Excel | |||
Change cell reference type | Excel Programming | |||
Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency | Excel Programming | |||
How to change type of the cell? | Excel Programming |