normal

Hi, I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ? 118362 119002 119246 119273 119316 <colgroup><col></colgroup><tbody> </tbody>

Hi, I need a formula that tells me 4 options based on a date in C3: Overdue= the date has passed Approaching= date is 5 days away Pending= normal status Complete: if A1 is = Yes then Complete What I currently have is this : =If(TODAY()-C3<=5, "Aproaching","Pending") I'd be really grateful...

Hello,</SPAN> At present using following volatile formula does it is possible to be converted in the normal formula</SPAN></SPAN> Book1EFG1233 | 0 | 0 | 2 | 2 | 2 | 1 | 1 | 13Sheet1Cell FormulasCellFormulaG3=MATCH(1000,INDEX(FIND(" | "&ROW(INDIRECT("1:999"))&" | "," | "&E3&" | "),0)) Thank...

Morning, I have the code below but would like some advise for a slight alteration please as i got lost with the yes / no part of it.. The code saves a screen shot in the form of a PDF file. The Yes / No box is where im stuck. Clicking No would just continue to save as normal Clicking Yes...

Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe

I have a few userforms on a sheet, but when I use them on a different sized monitor, they resize (often much larger) and the contents are not organized well like I have them set. As soon as I go in the VBA Editor and resize them back to normal, they take on all their old formatting, but I was...

On my worksheet, cells A1 through to B6, I have the values 1,2,3,4,5,6 from A1, A2, A3, etc. In cell D1, I type: =SUM(A1:A3*B1:B3) and enter it as an ARRAY formula to get the result of: 32 I understand how this is arrived. It is multiplying cell A1 with B1, then A2 with B2 and then...

Hi friends, is it possible to add formula after index match in vba , in normal index match its working but not with vba. vba code Sub lookup() lastrow = Cells(Rows.Count, "e").End(xlUp).Row For i = 2 To lastrow Range("e" & i) = Range("b" & Application.Match(Cells(i, 4)...

Hi all, bit of a long shot, but... Does anybody know if I can update a chart automatically as more data is populated, over time? In Excel 2016. I have a set of data in various pivot tables - these Pivots update when I open the workbook each time using auto-refresh within the Options menu of...

HI, How large are ODC files? I have one that is 3mb, even when I reduce it to a few lines. Itis slow and lumbering. Is this normal fo ODBC files? Thanks

I am Daphne from the Netherlands and I have a urgentquestion. I have to make a sheet/formulas for work. I can work with Excel but don’t have the whole knowledge of it. Ok what is my issue. I hope I can explain it correctly in myDutchy/English. Sheets contains personnel names, days, start...

Morning, I am trying to figure out how to get Excel to integrate with another program that is not a MS program. All i am wanting to do is take a selection of data out of Excel, cell L:L and paste it to the fields in this program into the Normal Bin Location. How would i do that with VBA?

code Sub test8() ' ' test8 Macro ' ActiveWindow.ActivateNext Application.ActiveProtectedViewWindow.Edit ActiveWindow.ActivateNext End Sub Hi Experts, I have a protected view file and a normal one. I am trying to run the above code from the normal one but I'm getting run time error...

I am Using a Forms Control button to run a macro. I would like to have the Button disabled till certain requirements are met. How can I disable the button. It is called Button 6 I have tried the following code but the button still works as normal even though the sheet is protected...

I was successfull in italicizing text in my textbox, but I am struggling with turning the italic format off to return the text to normal. With uf9_poststaff .pin.Enabled = True .dcard_id.Enabled = True...

Hi Everyone, I put the Microsoft Date Picker in a cell and I noticed every time I open the workbook I have to work the mouse wheel to get it to activate. Is this normal and/or is there a way around that? Thank You!

Can someone please help me? I have a Query Table of climate data from 1/1/1900 to today which I update regularly. I wish to calulate the mean High for each of the days (e.g., month 2 day 19) and compare it to the High for each date (e.g. all of the Feb 19s), subsequently indicating whether it...

Hi, I have this If a = 56 Then b = session.findById("wnd[0]/usr/ctxtAEDAT-HIGH").Text How do I get the session.findById("wnd[0]/usr/ctxtAEDAT-HIGH").Text part of the sting to run as normal code, since it comes now out of a sting?

Got a file from another company. It is showing two coordinates for each cell. It has numbers across the top rather than letters. Has anyone ever seen this before? Is there any way to convert to normal Excel?

I would like to a cell auto-populate with items from drop down lists that are not normal values. I have cells of medical problems all have a drop down list with a normal item first, followed by abnormals. If an abnormal item is placed in the field I want it to auto-populate a cell so I can list...