custom

Hi No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm). Why excel does not change the format of the time I entered to "Time" instead of "Custom" ? <tbody> I entered excel convert custom 1:00:00 am 1:00:00 AM h:mm:ss AM/PM 1 am 1:00 AM h:mm...

Any really for idiots guide to making custom Ribbon buttons? I'd like one that toggles between "Center Across Selection" on and off. Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button. Is this possible? I downloaded the...

Evening, I’m looking for a msgbox but with buttons as 1 & 2. Is there a way to do this without it being a userform. Thanks

How do I create a custom number format that always returns 5 digits? Examples: #2 = 00002 #2 2 = 00022 #2 22 = 00222

Hi I have the data below and I want to hide only positive numbers. So I went to Format Cells --> custom and typed ; I thought that would ignored the +ve only since I did not write anything for the positive. I know custom format is like this positive; negative; 0; text so ignoring positive...

I'm trying to make a custom sort based on a contact's management level. Basically sort by their title. So the list would sort something like this: Owner, CEO, President, Vice President, CFO,etc... The list works fine when the title is exactly as in the custom list. But if the title is a...

I have code to insert a set image. Could someone tell me how to alter it so it can insert a custom image please? Sub cmdJakeSig() Dim shp As Shape Set shp = ThisWorkbook.Worksheets("sheet1").Shapes("textbox4") Sheets("Sheet2").Shapes("ImgJ").Copy Sheets("sheet1").Paste...

Hi I want to write a custom formatting code to do the following: <tbody> user enter excel shows 1 1 200 200 1000 1 k 1245 1.245 k 55 55 </tbody> Is that possible? Thank you very much

Hi All! I am new to this forum. Need help. I need to separate units from quantities. i am not being able to do it because cells that are custom formatted and no text function works on these. When converted to text format, the units automatically disappears! Can you please help me out on this.

Hi, I'm having some issues with date formats from a workbook downloaded from a Govt/County site. The date as downloaded shows as two different date formats inside one column: 03/17/2016 02:22:00 PM - formatted as General, and 2/09/16 13:29 - formatted as Custom (d/mm/yy h:mm) The issue is...

I am familiar with using Custom Sorts for secondary sorts in tables. However, I was wondering if there is an easier way. Generally, one can simply click on the drop down arrow in a column header while holding the control key to designate it as a secondary sort, but that doesn't seem to work in...

Hello Friends Can anyone tell me if it is possible, and how to enter multiple logic in the custom auto filter ? For example, for a data set, I would like to filter between 7 AND 8, 8 AND 9 , 9 AND 10...and so on. Cheers Rush

Using Excel 2013, is there a way to create a custom date filter to filter all dates that are >90 days ago: >today()-90. When I type this into the custom filter formula, it isn't working.

hi all.. how to make custom number format like this <tbody> entry-input expected result - display 2% Tax Ratio (2%) 10% Tax Ratio (10%) </tbody> any help, thank in advance.. .sst

Hi: I am seeing strange behavior when I have 2 Excel files open that both have the same custom RibbonX. It seems to hide all viewable RibbonX menus on the deselected file. And, the behavior seems to be erratic and randomly occurs. Is there a way to isolate the custom RibbonX actions to the...

I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and do the same thing, and so on. In VBA the coding would be: 'Copy cost centres in column A to...

Hello everyone, long time lurker and big fan of the site. It's helped me many times. I'm hoping you can help with a question Basically: 1) I've created a slicer for a pivot table 2) I created a "Custom List" through Options-Advanced to rearrange the order of the items inside the slicer to what...

Say I have a table of 4 columns and I use power query to add a 5th custom column. Instead of loading the query to a fresh new excel table of 5 columns, can I instead, only load the 5th column to the source table in the worksheet? One reason could be to allow editing source data and also see the...

Hello: I have many columns from left to right in my spreadsheet. I find myself always hiding columns to view data then un-hiding columns to view other data. Is there a way I can set up a macro or a saved quick or option so I can set up different views? In other words can I for example view #1...

Note: Need a solution in power query (no VBA). Please refer to image below. There needs to be a new custom column added like the green one highlighted below, that would automatically find last reading for the relevant ID, even if the columns are not sorted.