Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a Column of Numbers Displayed as Text to Numbers
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a Column of Numbers Displayed as Text to Numbers
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) "cardan" wrote in message ups.com... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a Column of Numbers Displayed as Text to Numbers
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 -- Gary "cardan" wrote in message ups.com... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a Column of Numbers Displayed as Text to Numbers
On Sep 12, 8:54 am, cardan wrote:
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a Column of Numbers Displayed as Text to Numbers
On Sep 11, 6:21 pm, "Ron Coderre"
wrote: 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) "cardan" wrote in message ups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
Changing A Column Of Text numbers To True Numbers: How ? | New Users to Excel | |||
Converting text to cell reference and column letters to numbers -please help | Excel Worksheet Functions | |||
Hex numbers displayed in scientific notation when importing text f | Excel Discussion (Misc queries) | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) |