| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert all cells in a range to a number
I have a application that exports data into an excel file. However
when you view it in excel it has those little green triangles up in the left hand corner. Next I have to covert the cells to a number. I want to do this with VBA. The following of course works, but does not get ride of the green trangle. Charts do not work until I covnert to a number. Range("D2:O9").Select Selection.NumberFormat = "0" Any help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert all cells in a range to a number
ToolsOptionsEdit(tab) & unselect:
Show Paste Options Buttons Show Insert Options Buttons -- Mike Q. "gumby" wrote: I have a application that exports data into an excel file. However when you view it in excel it has those little green triangles up in the left hand corner. Next I have to covert the cells to a number. I want to do this with VBA. The following of course works, but does not get ride of the green trangle. Charts do not work until I covnert to a number. Range("D2:O9").Select Selection.NumberFormat = "0" Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a range of cells into individual worksheets? | Excel Discussion (Misc queries) | |||
| Finding Number Within Range Then Copying Data Below Number to Cells | Excel Programming | |||
| convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
| convert cells to negative number | Excel Discussion (Misc queries) | |||
![gumby[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
