Having macro convert text to numbers

[punter]

Hi,

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

Thanks as always,

Eddie

[Gary''s Student]

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.
--
Gary''s Student


"punter" wrote:

>
> Hi,
>
> I have a sheet of several thousand rows and about 25 columns. When I
> export the data into excel there are many numbers that come through as
> text with the little green triangle in the upper left hand corner. In
> the past I would just manually change them by highlighting the cells in
> questions and hitting the pop up box that let me convert the text to
> numbers. When I record that step of manually converting the text in
> the macro recorder nothing happens. Does anyone know how I can have
> macros convert this data for me?
>
> Thanks as always,
>
> Eddie
>
>
> --
> punter
>
>
> ------------------------------------------------------------------------
> punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
> View this thread: http://www.excelforum.com/showthread...hreadid=551258
>
>

[Gord Dibben]

GS and punter

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


Gord Dibben MS Excel MVP


On Mon, 12 Jun 2006 18:07:01 -0700, Gary''s Student
<[email protected]> wrote:

>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.
>--
>Gary''s Student
>
>
>"punter" wrote:
>
>>
>> Hi,
>>
>> I have a sheet of several thousand rows and about 25 columns. When I
>> export the data into excel there are many numbers that come through as
>> text with the little green triangle in the upper left hand corner. In
>> the past I would just manually change them by highlighting the cells in
>> questions and hitting the pop up box that let me convert the text to
>> numbers. When I record that step of manually converting the text in
>> the macro recorder nothing happens. Does anyone know how I can have
>> macros convert this data for me?
>>

Gord Dibben MS Excel MVP

[punter]

Both those ideas work. Thanks.

Eddie