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

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

GS and punter

Save a couple steps by copying a blank cell and Paste SpecialAdd


Gord Dibben MS Excel MVP


On Mon, 12 Jun 2006 18:07:01 -0700, Gary''s Student
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

Both those ideas work. Thanks.

Eddie


--
punter


------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=551258