convert text to numbers

  1. R

    Converting text amount to a number that excel sees as numbers and not text

    Hi there, I have copied a dataset from word to excel but now excel does not recognize the amounts as numbers so I cant do any calculations. The numbers appear as 3 258 124. I've tried to remove the spaces but excel cant find any spaces so it must be a special character. Please help. Thanks...
  2. E

    Paste Special Multiply on blank cells

    I am attempting to convert cells that are stored as text to numeric values. I have spreadsheet with cells showing numbers as text. I format a cell as numeric, copy that cell, select the cells to convert and go to Paste > Paste Special > Multiply. The cells in columns with text in them are...
  3. E

    Excel VBA unable to get the AverageIf, Run-time error 1004

    Hi! Please help me to solve a problem. I have Excel’s reports created by some analytic software. There are many data there. One of my actions is to apply AverageIf function for two columns (average from L column based on G column criteria). Moreover L column numbers originally go as a text...
  4. B

    Extracting numbers from a text string to use in a calculation

    I am trying to extract numbers, some of which are fractions, from a text string to use in calculating the weight of the material in a list. Example from cell D14: Bar 4x1/4 I was able to extract the "4" with =VALUE(MID(D14,SEARCH(" ",D14,1)+1,(SEARCH("X",D14,1))-(SEARCH(" ",D14,1)+1))) but I...
  5. F

    Looping through sheets and changing text to number based on a variable range

    This should be easy, but I can't for the life of me figure it out. I have a workbook with 20 sheets, and column C in all of the sheets contain numbers that are stored as text. I want to loop through each sheet, define the max rows in column C as a variable, then convert C2:Cvariable from text...
  6. X

    If Statement with Text as a range of Values and Numbers needed as Output

    Hey guys and girls, I found this website via Google trying to solve a problem I'm trying to solve with Excel 2010, so I decided to make an account and post my problem here as it seems a friendly community. I have the following list (showing part of it)...
  7. R

    Macro Convert Text to Numbers Allow Type mismatch

    Folks: Found this Macro that works to Convert Text to Numbers: Sub Enter_Values() For Each xCell In Selection xCell.Value = CDec(xCell.Value) Next xCell End Sub Problem is it "breaks" when it encounters text that can not be converted to a number: Run-time error '13': Type mismatch How...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top