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 |
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 |