LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
no row numbers or column letters DISPLAYED RagDyer Excel Discussion (Misc queries) 4 April 24th 23 03:42 AM
Changing A Column Of Text numbers To True Numbers: How ? Robert11[_3_] New Users to Excel 2 March 4th 09 09:08 PM
Converting text to cell reference and column letters to numbers -please help Jason Lang Excel Worksheet Functions 6 March 6th 08 06:18 PM
Hex numbers displayed in scientific notation when importing text f Gabriel Nehmer Excel Discussion (Misc queries) 2 July 20th 07 04:08 PM
Converting numbers formatted as text to numbers Bill Excel Discussion (Misc queries) 1 July 19th 05 07:10 PM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"