convert

Is there any way to convert a Month name to date format? It should be the last day of that month and current year. Example: June should be converted to 06/30/2019 July should be converted to 07/31/2019

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=...

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

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

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

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...

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...

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...

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

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.

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,

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...

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...

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...

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

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"...

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

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...

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...

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...