Convert all cells in a range to a number

G

gumby

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

Guest

Tools>>Options>>Edit(tab) & unselect:
Show Paste Options Buttons
Show Insert Options Buttons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number displayed as text difficulties 4
Excel Convert text to Number 9
Change cell type 3
Convert a range of numbers to strings 2
number format when returning value from odbc connection 2
can i format a group of cells based on the number entered in a cel 1
Count latest number of continous not-empty cells in a row. 11
macro to change number format of a highlighted range in Excel 2007 4

Top