Macro for converting text to numbers
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macro for converting text to numbers

  1. #1
    Guest

    Default

     
    I have an entire column that I need to perform a sumif calculation on. Problem is, when the file was originally exported, it converted all the numbers to text. Can anyone help me with the code that will convert an entire column's entries from text to numbers?

    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No code needed. Just select the column of data, choose the Data | Text to Columns... menu command and press [ Finish ].

  3. #3
    Guest

    Default

      
    I can't seem to get that to work. It tells me that the data is delimited and then i go through a 3 step process. At that point, the text still remains text and not numeric. Is there something else I need to do?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com