Converting a Column of Numbers Displayed as Text to Numbers

[cardan]

Hello,

I have a situation where I think an easy macro would do the trick,
however, I am somewhat new to macros. I have a set of numbers that I
import from a different accounting program. The numbers that are
imported, are the accounting codes and they are all in column A and
are seen by Excel as text. I can convert them to a numbers, but the
process is time consuming. Is there a macro that will convert the text
numbers in Column A to actual numbers?

Any help would be greatly appreciated. Thank you in advance.

 

[Ron Coderre]

There are a handful of techniques...

Try this first:

Select the one-column range of "numbers"

From the Excel Main Menu:
<data><text-to-columns>.....Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)

 

[Gary Keramidas]

you can try this:

copy a blank cell
select all of the cells in the column you want to change
right click, select paste special
under operation, select add
click ok

 

[christie.taru]

Hello,

I have a situation where I think an easy macro would do the trick,
however, I am somewhat new to macros. I have a set of numbers that I
import from a different accounting program. The numbers that are
imported, are the accounting codes and they are all in column A and
are seen by Excel as text. I can convert them to a numbers, but the
process is time consuming. Is there a macro that will convert the text
numbers in Column A to actual numbers?

Any help would be greatly appreciated. Thank you in advance.

Just multiply those column A with 1 in a different column, this should
do the magic!

 

[cardan]

There are a handful of techniques...

Try this first:

Select the one-column range of "numbers"

From the Excel Main Menu:
<data><text-to-columns>.....Click [Finish]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)

Hello,

I have a situation where I think an easy macro would do the trick,
however, I am somewhat new to macros. I have a set of numbers that I
import from a different accounting program. The numbers that are
imported, are the accounting codes and they are all in column A and
are seen by Excel as text. I can convert them to a numbers, but the
process is time consuming. Is there a macro that will convert the text
numbers in Column A to actual numbers?

Any help would be greatly appreciated. Thank you in advance.- Hide quoted text -

- Show quoted text -

Ron, Thank you for the response.I think the Text to Columns will work.
However, when I record a macro is there a way to have the macro
automatically select the last cell in the column? Thanks again.