display

I am trying to figure out how to create a custom format for numbers. Is it possible to do this? Positive Number Display (in color black) 145.00 Negative Number Display (in color red) (-145.00)

I don't know why I cannot remember how to do this...but... I have a time cell and I just want to type "1753" in the cell and for it to display as "17:53". How do I have it automatically add the ":" to that cell?

I have a column of unique text values that are URLs (web addresses). I need to convert all of them to hyperlinks that point to the unique URL but want all of the rows to display the same text. My actual dataset is hundreds of rows. Data www.1234.com www.5678.com www.9101.com Desired output...

My workbook sheet tabs would be named by Year (i.e. 2018, 2019, etc). Currently I have one sheet (i.e. 2019). I would like to display in a combo box the previous 2yrs (i.e. 2018 & 2017) and also the following year (i.e. 2020). Maximum years displayed should be limited to 4. (i.e. 2017 -...

Can someone explain how to write a IF formula in excel? If cell 10% of B9 is greater than 35, display the value, otherwise display 35.

Hi newbie question please. I'm trying to create vba for checkbox when checkbox = true, display date/time else display blank/null Thanks in advance:)

Hi there, I have 3 tables with codes and prices (codes are not formatted like the below). I want to enter a value in J2 and if that value is in any of the tables I want the PRICE for that table to display in K2. I can do it for two tables where it displays one value or the other using...

Hello, I am trying to figure out a formula which will search a separate sheet for four different phases. Then, display the one phrase that is in the sheet. I need to search the exact phrase and the cells it is search will only contain that phrase ( i.e. I’m not search a paragraph of text) I...

I have this code below that I can not figure out why its given me a this error. lbSL are userform labels that display percentages. Please help. Thx Range("Z1") = WorksheetFunction.Max(100, CDbl(lbSL)) - CDbl(lbSL)

Hi All, Wonder if you could help. I am trying to transfer the list of results from a filter on a column on one sheet and display the list onto another column on another sheet. For example: to this Any ideas? Thanks

<tbody> A B C 1 5/1/2019 2 OK 510 3 TX 690 4 CA 300 5 NY 100 </tbody> I'm looking for help designing a formula that can lookup data and can be nimble enough to return new data if I change either the date in C1 or the display name in B2:B5. The display name in column B is a...

Hi, Have code that hides the sheet tabs: ActiveWindow.DisplayWorkbookTabs = False Unfortunately, the User can change this via: Excel Options->Advanced, section Display. Is there anyway to prevent the user re-enabling the display of workbook tabs? In this instance Sheet.Visible =...

Hello, I have an external connection pointing to an xml which display some values. Sheet1: Values Sheet2: External values I managed to do it with Vlookup but since the XML sometimes doesn't updates correctly and points to "zero" (since it can't read it from external source) I will want to...

I have data is three cells (M15, M27 & M39). They may have various text in them, but only one cell will be either "Overtime" or "PointinTime". In cell M44 I would like to display the data from whatever cell contains the either the word Overtime or PointInTime. I am unsure how to do this. I...

Is there a way to have a cell value equal the "2019" and have this value used for formula calculation purposes but have the cell display "2020", even though it's value would be "2019" Thank you

compare 2 (A & C) columns with numbers and display the numbers that are in the first column and not in the second column in the column E then display the numbers that are in both columns (A & C) in column G

I tried to explain as simple and completely in this title. I have this and it is hard coded in the vb Workbook Open event code window If Day(Now) = 8 Then MsgBox "See if anyone on MrExcel can help" Else End if All this does is display a predefined Msgbox text string on a predefined day...

I need to adjust this formula C21+($I3+($I3*$D11)) so itwill either display the results of this calculation OR the value in J3, whicheveris lower. Thanks in advance

Good day I am trying to rename a folder of PDF's. The challenge is that to get the new name the file must be opened and the new name typed out. I have been trying to use a userform to display a previe of the files however I am struggling to accomplish this task. Any help is appreciated...

I am trying to open an Excel xlsx file using Excel Online, and I get the message "can't open the workbook in the browser because it uses unsupported features", and then lists "display of formulas in cells". But I'm not using display of formulas in cells. Can I get some advice? g