custom

Hi have researched custom format of cells, but have not been able to find a response which deals with my issue. Is it possible to have a cell display as 3*3, 4*4, 5*5 and so on? So regardless of what number is typed, it displays as number*number. Is there as way for this to be done? Thanks in...

I tried the custom format and enter HHmm custom but when I run the macro after hitting the arrow it will displayed the date instead? Thanks

First time poster, and let me apologize right off the bat if I'm asking a question that has already been answered. I've tried searching for an answer but haven't found what I need yet. I'm also a first-timer to VBA as I'm finishing up my first project. I don't really know coding that well but...

Hi all, I want to put validation in a cell that should only accept the value of the sum of let’s say column “G”. I used the formula, =SUM(OFFSET($G$2,0,0,100,1)) but it rejects all values. Please advice. Thanks

I've been working a lot recently with custom number formats and if using custom number formatting takes up my memory than cell fill. This came to my attention when I was ";;;" to hide the cell contents from view as opposing to using a white fill or a white font. I am curious to find out if...

Hi all, I'm trying to write a macro that will filter a database to show rows that only contain certain keywords. I used the macro recorder to recorded a custom filter but have been unable to adapt it for more keywords. Below is the recorded code. Any ideas on how I can get it to filter more...

I'm using the below formula in the custom area when formatting a cell. The displayed result is a single digit. I need this to display _.__ , two digits after the decimal place. What part of this needs to change to reflect that? _(* #,##0_ );_(* (#,##0);_(* "-"??_);_(@_) Thank you for your help.

Hello I'm running Excel 2019 and I very recently added a pivot table/chart to my workbook, which has 15 other sheets. I've been making good use of Custom Views and although I read that Custom Views won't work if there's a table in the sheet, every sheet in my workbook already contains tables...

I have a field on that table that in excel is defined as custom H:mm. It is a duration of session field. The data will be 1:00 or 00:30, for one hour or 30 minutes. In the Crystal report it is showing as 12/31/1899. This is a downloaded excel from a report in the EHR.

I use several macros to help me convert numbers that do not work when I use custom cell formatting. Below is an example of the VBA I use to multiply a cell value by 1000 or add formula to do so if formula is present. Sub MUL1000() Dim cell As Range For Each cell In Selection If...

Hi I made a custom tab on the ribbon. There is a way to get the status of the checkbox ? Can i acces the checkbox by it's name ?

I have a cell pulling in data from elsewhere and converts to time in the custom format hh:mm. However, these times are frequently over 100 hours so I really need in the format hhh:mm. However, this is not a format that is available under custom. How am I able to do this?

I have a very large, complicated workbook that I created back in the pre-ribbon days that we use every day. Each day, it creates a new worksheet and when the workbook is closed, it renames the sheet based on the date and saves it as a separate workbook. Then, 5 days later, the new workbook is...

Hi I have a custom view named "All Routes List" I'm trying to activate this view when the worksheet named "Analysis" is opened. I've tried inserting the below code in the worksheet: Private Sub Worksheet_Activate() CustomViews("All Routes List").Show End Sub And it returns "Compile error -...

I'm trying to do something that I had thought simplistic, but the formatting of the result is causing me issues. A1 = 1/8/2018 23:10 A2 = 1/8/2018 23:29 A3 contains the formula =A2-A1. Then, I am formatting it with the following custom format: yy\y mm\m dd\d hh:mm:ss I am expecting to see 00y...

Hi My computer date setting is mm/dd/yyyy. So I selected a cell and then I went custom format--> dd/mm/yyyy. But when I entered 13/1/2018 excel did not take it as a date/number, it kept it in the left hand side of the cell. But when I enter the date as 1/13/2018 excel will accept it as date and...

I would like to create a custom function for use within an IF(AND(OR . . . formula, but I have no idea how to convert specific cell references into generic form or how to refer to cells in the preceding row, or in fact if what I'm trying to achieve is even practicable; maybe I've totally...

Is there a limit as to how many custom formats Excel can contain? I read somewhere it might be 64,000 (based upon a workbook with 100 sheets or so). Is there a limit to how many custom formats (i.e. fonts, typeface fill, alignment, numeric, borders, conditional formatting) that Excel can hold...

I have a string that looks like this: 10N23w05 I need it to look like this 10N 23W 05 In other words, with a space where indicated. Further complicated by the fact that some of the 50000 instances already have a space. they don't need another space entered. Is there a custom format,or...

I am using the DateTime picker and it will not hold the custom format even though it shows it has not been changed in the DTPicker properties. I have tried hard coding using dtpicker1.customformat but that doesn't hold either. Is it possible to create a date/time picker without using the activex...