custom

Hi I thought I had found an amazing solution to an issue whereby a column I wanted to filter had blank rows in between. I autofilled the rows with the value above but as I didn't want the text to show no matter what the cell colour was changed to, I formatted the cells using custom ;;; this...

Maybe the Alzheimer's is worse than I thought. I am trying to use this custom format to get numbers right-justified, but with a small margin on the right. 0.00_. It works almost all of the time. There is one situation in one workbook where it fails and I cannot figure out why. If I enter some...

Hello, I am new to using query and I am trying to extract data from a report in an excel file (report_1). The first 5 rows in the excel file are irrelevant (report details and caveats) with the information laid out with column headers in row 6. I have created a query to extract the...

i'm losing sleep y'all... Cell a1 has 1:40:35...cell a2 has :45, so selected a1 and dragged the anchor down to a2 and clicked "Formatting Only", but it remained :45. why??? I've tried every "time" and "custom time" cell format option.......no change:crash: any help :huh::pray:

hi all... i need your help to figure it out this problem use Custom Number Formula <thead> entry expected result </thead><tbody> 11 1.1 23 2.3 41 4.1 32 3.2 </tbody> any help greatly appreciated... sst.

Two part question. I currently have 6 macros in my workbook will likely grow to +-10. I created a Custom [Ribbon] Tab with One Group With 5 macros in the group, the macro and icons present fine When I add a 6th one, the first three item appear in full size but the last three are stacked one on...

Thanks in advance for your assistance. I have produced a Leave Diary builder in Excel 2010 which has a custom ribbon tab. Based on the name of the workbook, I show or hide certain buttons on the custom tab. When I open the workbook it shows only the one Build button on the custom tab. If...

Thanks in advance for your assistance. I have produced a Leave Diary builder in Excel 2010 which has a custom ribbon tab. Based on the name of the workbook, I show or hide certain buttons on the custom tab. When I open the workbook it shows only the one Build button on the custom tab. If...

I am working on a project where I have numerous userforms and each as a date that auto-populates in a text box, well it used to populate. I name the userform a custom name, but when I double-click the userform to view the code, it no longer uses the custom name, but rather defaults back to...

I would like to create a custom number format where millions are displayed as thousands. I know the formula for that is #,##0,;-#,##0, My problem is that I also need to add an accounting offset dollar sign. So I need $ 1,000,000 displays as $ 1,000 with the dollar sign in the same position...

Hello, I create a custom menu called Marks and I want to access it through a shortcut (for example CTRL+M). Can anoyne help me with the vba code to display it. I want the same effect as ALT+SPACE BAR for displaying Control Menu Thanks in advance.

Hi, I have uploaded a template to be used within the organization on an online sharepoint and get the following error when trying to open the file in the browser: We're sorry. We can't open the workbook in the browser because it uses these unsupported features: • Custom properties linked to...

A co-worker sent me an excel sheet that I am attempting to print. But when I go to the print screen the page size states that it is "Custom Page Size" with an orange dot. So i tried to change it to 11 x 17 but it wont change, it stays at the Custom Page Size. I tried "save as" and I still...

Hi. Is there a way I can make my own stock screener that will pull data off line so I can sort by my own custom parameters?

Hi guys, just facing problems with an importet file. Can someone tell me how I need to custom format so it shows the correct time in excel <colgroup><col width="176"></colgroup><tbody> 2017-12-30-09.28.28.937036 so it shows the date and time correctly? Many thanks for your help! Albert...

Hi Guys, I need a formula that performs the below. It should be easy but I can't nail it. IF E8 = BLANK (No value) then "custom text", otherwise (if not blank), is the value >6 if true "custom text" otherwise " " (no value). I was thinking something like... =IF(ISBLANK(E8),"CUSTOM...

Hi I am looking for a custom search macro that does the following: I enter a date into a custom search box then click search. Then whichever sheet I am in, the query then only searches Sheet 1 ("Training Log") and makes column H of the row containing that date the active cell. Hope you can...

How do I express this in a custom formula? if AmyFinanced="" and R73="Yes" then error alert

Hi, I am trying to replicate the behavior of an .xlsm file I have. When I open it, I have a custom tab showing. However, if I go into the "customize ribbon" section, it's not there. There also doesn't seem to be any macro running on the workbook open event. Also looked in quick access toolbars...

hi all.. how to creating Custom Format to typing Latitude & Longitude like this : case 1 (Latitude) <tbody> data desired result 1679755 1.679755 18632547 1.8632547 </tbody> case 2 (Longitude) <tbody> data desired result 101429118 101.429118 101419375 101.419375...