text to number

  1. D

    Convert Text to Number

    Hi, I've spent nearly a day on trying to find a solution to my problem. I've created a data entry form which goes into an excel sheet, one of the columns is in £ and obviously the value that is entered ends up being text instead of the required format, Accounting. I've tried code relating to...
  2. S

    Sumproduct, extract numbers from text

    Hi, I receive an automatic dump of data on a weekly basis that looks like the below Table A. Basically, the first column is by category and the remaining columns are by week. How would I summarize the hours (found within the text) into Table B, which would summarize it by category (A,B,C) and...
  3. J

    User Form

    Hi All I am creating a user form to capture date on a ws - I have got most of it to work but am stuck on 2 places:1. All numbers on the user form is copied to the ws as text - should be numbers 2. I need to put a formula on column R (irow, 18) & Z (irow, 26) R =max(previous 7 columns) ie...
  4. M

    Keep Export Format

    Hello, I have an issue with my Excel export. When I export an Excel file from a data base some cells are converted and I would like to prevent that. For example in my data base date are written like this: 01/Sep/2015 but when I open my file excel convert it to 01/09/2015 The weird thing is...
  5. C

    convert Text to Number in multiple sheets simultaneously

    Hello all! I am trying to select multiple sheets and convert the text to number in all of them simultaneously but everytime I run the macro only the first one does it. Any feedback on this code please? Sheets(Array("Countries_Send", "Countries_Receive", "Party_Send", "Party_Receive", _...
  6. S

    convert number stored as text to number without rounding the numbers

    Hi All, I am looking for a VBA code for the below issue, Please help. I am stuck where i have to convert the number which are stored as text and i have to convert them in number format and it should not round up the numbers. Below is the sample data for your reference. once data gets convert...
  7. J

    Multiply Array Value to Convert Text to Number

    In my excel file I have Numbers that are stored as Text and by multiplying the value by 1 it is normally solved (i.e. the cell value becomes a number). If I do the following simple test it works: Range("A1") = Range("A1") * 1 Now I have a big file and I want to use an Array to do so but it...
  8. J

    Need expertise on assigning numeric value to text cell and copying that value to another cell.

    I have an Excel file I am using as a grading rubric. I have 5 different cells with text only in them. I need to be able to click on the cell and generate a score on the sixth cell, which is empty. For example, if I click on the first cell with text, the score is 1 and that 1 needs to appear...
  9. H

    Convert text to number for a table

    How can I convert a large table of numbers stored as text to actual numbers...without going one by one? I tried highlighting all cells in the table and formatting them from text to numbers, but this didn't work. Thanks, Jeff
  10. C

    Text To Number HELP!

    I have a cell which reads '100 - Dave Whitman'. The 100 is the depatment number that I need to extract. I used LEFT(Cell, 3) to extrat '100' from the cell. I now have a new cell with 100 in it. When i use that cell in formulas, it does not work because it is not a number. I tried changing the...
  11. M

    Convert text into number

    Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Hope you can help me cus i been everywhere and tried everything already.<o:p></o:p> <o:p></o:p> i need to convert all the numbers in a sheet from text to number format so it would do the...
  12. K

    Manipulating text string via clean, proper, right

    Guys, Pardon my ignorance but these got me stumped. I've received an excel file which contains name and personal id both keyed into the same cell separated by "enter" key. I've used clean, proper and right functions separately to get to this sample output:Excel WorkbookBCDE2AZURA BINTI...

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