convert

Hi all, I thought this would be a straightforward exercise. I have a column that is a YEAR, but it's a GENERAL data type. I need to convert that to a date, basically the last date of the year, 12/31/2018. example; 2018 --> 12/31/2018 I have a column that has years beginning from 2018 going to...

Hello Everyone Good day, I'm using below VBA code for last 1 years and today I discovered the small error in VBA code . When I write minus -10,000 it shows on "Only Hundred Ten Thousand" When I write positive 10,000 it shows on "Only Ten Thousand" works fine Can someone please correct my VBA...

Hi, I have a complicated situation with an unwieldy amount of data. The situation is I have data from my website in excel, each row is a profile (around 100k profiles), that all biographical data is crammed into one data field (or in this case, a cell, since in Excel) in HTML format. The HTML...

Hi guys, I have looked online to try and find some solutions but I keep getting an error. Perhaps I am messing up with the syntax. I want the vba to go to the worksheet titled "Index", and then to convert all of the data on that sheet into a table called "Source" (similar to going to the...

Hello I have downloaded a report and the date in the above format stored as text. I would like to change it 15/10/2019 to create a Pivot table. I have tried datevalve, format the cell to date but no joy. Any pointer please. thank you.

Hi Gurus, Could you possibly help me build a codes for this one? Basically, I have a folder with excel Files: Folder Name: Data Sheets The folder contains different sheets example: 1. Data 1.xls 2. Data 2.xlxs 3. Data 3.xls 4. Data 5.xlsx ..and so on Is there any way, where I can convert...

Hello All just trying to get the following array formula to a non-array {=IFERROR(INDEX(TRADES!$D$2:$D$2000,MATCH(1,(TRADES!$A$2:$A$2000=B3)*(TRADES!$C$2:$C$2000=DATE($F$1,$N$1,$E$1)),0)),"")} Thanks

Hi, I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database. Thanks

I have software that exports date data to a workbook. I am expected to utilize this data to feed another report. The issue is all of the dates are exported into text, I have to update this weekly sometimes ad hoc when requested. I was wondering if I could modify my macro to somehow get around...

Hello, Which is the correct way/formula to convert the currency cost into a formula. For example: $39.21 shows as 3921% - May I know which formula I should use to get the percentage in a correct way. These are the sub-totals cost I have and I would like to show them in a percentage form...

I'm working on a time study. I need the formula to convert numbers of hours worked on a task in an 8 hour day into a percentage.

=HH31+HH32+HH35+HH36 =HH40+HH41+HH44+HH45 =HH49+HH50+HH53+HH54 =HH58+HH59+HH62+HH63 =HH67+HH68+HH71+HH72 =HH76+HH77+HH80+HH81 These formulas start in DQ32 and end in DQ923. Each are 9 rows apart. Need a macro to run these formulas and convert them to values

will someone help me to convert the following formula in access. LOOKUP(2,1/((SEARCH($D$1&"*",BOM!$I$88:$I$2617))*(BOM!$C$88:$C$2617=Sheet6!A6)),BOM!$D$88:$D$2617),"") Thanks in advnce

Hello I have a column A1 (Time) which has the following data and since it does not have similar formatting I am finding it difficult to convert it into minutes. Any help would be appreciated. <tbody> Time Minutes 1d 3h 42m 1662 18h 38m 1118 34m 34 7h 5m 425 </tbody> Regards...

Need to macro to convert selected tabs to PDF Say in A1 to A10 is the tab name and the in B1 to B10 is true or false If it is true in B1 to b10 then it will convert them to PDF

Hi I want to convert time to general (number). I want the numbers to be appeared like this 1/24, 2/24, 3/24,...., 24/24 I changed times to fractions format but I did not get what I want. In some cases like 10:00 pm, the fraction format changed it to 1 instead of 22/24. Thank you very much...

i copied numbers from an online account. pasted them into excel 2002. how do i convert the numbers to numbers i can multiply etc? i tried putting a 1 into a cell then copying and paste special multiply tried converting the cell to numbers thanks all

Hi All, I don't know if this is easily do-able or not: I have a vertical list of tasks with sub tasks that have to be completed at a certain time before the project end date. To make it easy, I would like to convert these items to a horizontal timeline which displays the tasks and sub tasks on...

I have a list of stock codes in randomised say A's ( out of order) , then B's etc and want to convert it to a strict A--Z list within each letter in other words, make it a proper A--Z list can some assist please thanks

Hey community, i use following formula to convert time to numbers. Sub Convert() With Worksheets("DATA").Columns(10) .NumberFormat = "0" .Value = .Value End With End Sub But for some reason it is working wrong, instead of converting it replace most of cells with column name. ( column name...