Having macro convert text to numbers


P

punter

Hi,

I have a sheet of several thousand rows and about 25 columns. When
export the data into excel there are many numbers that come through a
text with the little green triangle in the upper left hand corner. I
the past I would just manually change them by highlighting the cells i
questions and hitting the pop up box that let me convert the text t
numbers. When I record that step of manually converting the text i
the macro recorder nothing happens. Does anyone know how I can hav
macros convert this data for me?

Thanks as always,

Eddi
 
Ad

Advertisements

G

Guest

In an un-used cell enter 1 and copy it.

Then select all the cells you want to convert (or all the cells) and
paste/special with the multiply button checked.
 
G

Gord Dibben

GS and punter

Save a couple steps by copying a blank cell and Paste Special>Add


Gord Dibben MS Excel MVP


In an un-used cell enter 1 and copy it.

Then select all the cells you want to convert (or all the cells) and
paste/special with the multiply button checked.

Gord Dibben MS Excel MVP
 
Ad

Advertisements


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

Top