convert

  1. Y

    Convert weekly data into monthly data in VBA

    Hello, I need some help I have a worksheet called data weekly. C4 to C108 are the date. (C4 = 2017/06/23) D3 to AA3 are the assets. D4:AA108 are the index of those assets. I want to convert those data into monthly data in another worksheet called data monthly VBA. (start from D4) C4=...
  2. A

    Convert x Days y Hours z Minutes to Minutes

    Need to convert something like: 4 Days 16 Hours 32 Minutes to something that can be added up or manipulated. Minutes is fine.
  3. P

    Tenth of a second to minutes

    How would I convert seconds displays as 10ths to Minutes? Would it be 34543 /10 /60 ?
  4. J

    Convert XML Files to Excel

    Hi Guys, Just wondering if anyone knows how I can convert XML files to EXCEL format easily? Thanks. Jay
  5. B

    How to convert date to Month/Year only

    Hi, can you please help me convert a date to month and year only. I have series of dates with the format (dd-mm-yyyy). I have customed the format to mm-yyyy but the day is still showing especially when I create a table and choose month. If I can just delete or remove the day, it would be...
  6. D

    convert =SUM(A1:A3) to =A1+A3

    Hi, I have a complex filtered list with multiple formula =Sum(up to 30+ cells) that will corrupt as i re-filter my data. Is there a way to change a formula or vba to convert from =SUM(A1:A3) to =A1+A3 etc. I would be looking to restrict the vba to a single column. Looking at having to...
  7. T

    Convert cell containing time to number

    I have cells that contain sums of time and I need them to show as 00.00 and not hh.mm The problem occurs when I have a sum of hours over 24 [for instance the sum of hours for an employee = 50:00 shows as 2.08 if I was to customise to a number] I know I can do it by adding another cell an...
  8. H

    macro to convert negative values with Brackets

    I have values and percentages in Col D:J on sheets 16 to 25 I would like a macro to convert the negative numbers only eg -125, -128,965 etc in these columns and on these sheets with a bracket eg (125), (125,965) etc Your assistance in this regard is most appreciated
  9. P

    Convert To VBA

    I have a MS Excel formula in a cell that I'd like to convert to VBA in order to use in MS Access. Would one you experts be so kind as to convert this formula into a VBA function. =LEN(SUBSTITUTE(C3, " ", "")) Thank you so much.
  10. Naveed Ul Haq

    Faster Way to Convert Text to Number

    Hi Everyone, I extract data from an ERP and then copy that data into another excel sheet but the problem is that the extracted data is stored as text and I have to manually convert it to number. Its a time taking activity, any faster way to get this sorted??? Regards,
  11. H

    Macro to convert text to numbers

    I have numbers that when imported appear as text in Col F I have tried to write code to convert these into numbers, but the text for eg '1.00. '3.00 etc will not convert to 1.00, 3.00 etc Book1A1Stock Holding21.0031.0041.0051.0061.0071.0082.0093.00101.00111.00122.00131.00Sheet3 Sub...
  12. T

    Best way to convert text date with VBA

    Hi all, I have a date that is being imported into my spreadsheet and comes as a long text that I want to convert to dd/mm/yyyy An example of how it is imported is this "Monday 3rd Jun, 2:10:40pm" What I want to do is get rid of the time and convert to just dd/mm/yyyy. Is there a way to do...
  13. E

    Error message - "The workbook you are pasting to uses a different date system"

    I am getting an error message when trying to copy a large amount of data and paste special values from one workbook to another. Help! Is there a work-around? The body of the text reads as follows: "The source workbook uses a different date system than the target workbook. Copying and pasting...
  14. M

    convert currency from numbers to words

    hello, i want to convert the rupees from numric to words. how can we do that?
  15. M

    Convert Excel to Vba Code msxml2.xmlhttp

    The code I wrote is also slow to take data from the site so I want to translate it to msxml2.xmlhttp. I need your support for it, if you help https://yadi.sk/i/DtV6aex_1I2lxQ <svg focusable="false" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"> </path></svg><svg focusable="false"...
  16. A

    Convert formula to VBA

    Is there a way to convert this formula to a VBA? =INDEX($D$14:$D$1880,$B$1-ROW($D$13))
  17. K

    Txt file convert to .xls

    hello. I wish to convert a txt file that is saved down in my folder into a .xls file. Before I do this however I need to sort by columns and I wish to sort by using the delimited file type - Other | key. Once created as a .xls file. I need to import the file into my workbook under...
  18. J

    Convert 8 columns to two columns

    How do you conver the following schedule How do you convert the following 8 column schedule Date Team ID <tbody> September 5 1 2 3 4 5 6 7 8 September 12 6 8 5 7 2 4 1 3 September 19 5 4 1 8 7 3 2 6 September 26 3 6 7...
  19. J

    Convert 8 columns to two columns

    How do you convert the following <colgroup><col><col><col><col><col span="2"><col span="2"><col></colgroup><tbody> September 5 1 2 3 4 5 6 7 8 September 12 6 8 5 7 2 4 1 3 September 19 5 4 1 8 7 3 2 6 September 26 3 6 7 2 1 5 8 4 October 3 7 1 4 6...
  20. B

    VBA to Convert Paths to Hyperlinks and Group by Folders

    This bit of code does a great job of listing all folders and files in a directory to a sheet. Sub cmdList() Dim sPath AsString Dim fOut AsVariant Dim r AsInteger Dim Cell As Range With Application.FileDialog(msoFileDialogFolderPicker)'.Title = "Select directory"...

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