converting

Hi All, I need help converting some macro found in MS Office 2003 into MS Office 2016. The following works in MS Office 2003 but does not work in 2016. Art.xls is stored in XLSTART folder and opens in Excel hidden . Another workbook contains the macro buttons that call an image from ART.xls...

I saw your example converting hex to ascii "=CHAR(HEX2DEC("4A"))". I would like to know how to convert a string of hex to ascii. There is example: 5238304d33335446462 and convert to R80M33TFF

Anyone know how I can type in 6E10 without excel converting it to a number? Thank you,

I'm struggling to come up with a formula to do this. Can anyone help? OLD SHEET: B9: Contact 1 B10: Contact 2 B11: Contact 3 NEW SHEET: C5:9 are merged and I need B9 to populate from the old sheet C10:14 are merged and I need B10 to populate from the old sheet C15:19 are merged and I need...

Hi I am having trouble converting times, i can get it to work so far but all times with a zero at the end show as 3 digit, is there a way to convert it properly please? thanks for any help D <colgroup><col style="mso-width-source:userset;mso-width-alt:8996;width:185pt" width="246">...

I need help in converting dates from this format: YYMMDD 180422 My desired result would be (with slashes): MM/DD/YYYY 04/22/2018 Any takers? Thanks! Eric

Hi All, I have a SUMIFS formula which performs as required, but would like to change it to SUMPRODUCT, to avoid the #value issue when the linked workbook is closed. I can't seem to get this to work. Can anyone assist in converting the below formula to SUMPRODUCT? =SUMIFS([Source]Sheet!N:N...

Hi all, I think this issue has been dealt with extensively but I am unable to find the relevant thread. I have a 20 digit number that excel is converting to zero's due to its specification. I am able to display the number by converting into text. However, I need to create logic which allows me...

If I have a corrupted XLSX or XLSM file, can I recover by converting it to a ZIP and reading the individual worksheet XML files? Ed

Hi, I need your help with converting my formula into VBA Code.Please can you help me with this code, it spring a runtime error on line 2. Why? Excel:Formula =IF(COUNTIFS(F3:F10,"NONE_TP")=0,"",(COUNTIFS(F3:F10,"NONE_TP"))) Sub TestPhase2 Dim ws As Worksheets<o:p></o:p> Dim lr As...

Hi, having trouble converting the intervals below which are TEXT. I need to convert 00:00 01:00 01:30 02:00 To 12:00 AM 12:30 AM 1:00 AM 1:30 AM 2:00 AM

Howdy folks, I have a spreadsheet in which I have a column of cells that all contain 7 characters. I am extracting characters 4, 5, and 6 of these cells via this formula: Cell H3: =VALUE(MID(G3,4,3)) I am then using the following vlookup trying to pair the data in H3 with a lookup table on...

Hi there, I have a userform which displays a time in a textbox (StartTime), for example 11:15 I have a second input box which the user types in the number of minutes a task has taken (TimeTaken) - this is always in minutes (eg 6hrs = 360) And there is a third textbox (EndTime) which is...

Hello, I have a huge list, I want to change my reference columns data from number to text. I don't want to add any new column and for instance, use text() function. I am just wondering if it is possible to do that in place with a VBA code or not. I tried selection=selection.text and...

While delimiting, I chose to import the date+time as text otherwise Excel does some kind of half converting. Therefor I format the cell as: m/d/jjjj u:mm:ss AM/PM But it does not get recognized as date. What am I doing wrong? :confused:

I need to convert 1/0 array to True/False array Example converting {0;1;0;1} to {False;True;False;True} Thanks

Hi All, I have an array formula as below that works as intended, but is really slow to calculate values due to the size of the dataset. Therefore my though to speed this up is to convert it to VBA. I have searched, however am struggling to find any examples online. Therefore any assistance...

So i want to hear if anybody know an easy way going from excel to ics file? Tried looking up to save as csv from excel and then convert it with online program to icv files. The problem is i once every week want to update about 30 peoples calendar but in more easy way then have to convert all 30...

I have two columns that read: XXHSXX HR XXTRXX MG XXXFXX XG XXHSXX HS XXTRXX MG XXMEXX R$ XXHSXX HR XXHSXX XXTRXX XXTRXX .... The above list represents 2 columns. The left column is 400 lines long. The right column is partially complete with 2 letter codes that represent...

Please help me solving this issue This is the data I have in my excel sheet. <tbody> Ware House Product Today Sale APE NP 50 CAN 30 CAN-C 80 UREA 90 BWP-1 NP 100 CAN 250 CAN-C 330 UREA 150 BWP-2 NP 200 CAN 210 CAN-C 320 UREA 400 </tbody> I want to change this data in...