format

I have several data validation dropdown lists [not combo boxes from the developer tab] that have more than 12 items in them. Is it possible to edit the list's format so they display more items in the list when the dropdown is clicked?

THANK YOU SO MUCH FOR ANY TIME AND EFFORT IN HELPING ME SAVE MANY MAN HOURS AT WORK!!!! I just need to take a large data set from the first format below to the second. The changes include: 1. New column 2. Each row from the original data set that begins with cell A containing "RE: $...

the cell needs to be "03-15-23" and I make a custom format ##-##-## but it leaves out the 0 at the beginning. what custom format can i make for this

I have 3 text boxes, accompanied by 3 spinbuttons. spinbuttons put day, month, year into the text boxes. When I enter the values into a cell, it's not in a date format. How do I convert it to a date in vba? Here's the code I used. Private Sub SpinButton1_Change() If Me.SpinButton1.Value = 0...

I'm building Pie Charts for a client at work and they are asking me to try and remove the Gray Line that goes through the middle of my Pie Charts. I've included the data set for reference. As you can see, only the 'Lab' User Group has any value in the SF column. Despite only the 'Lab' User...

Hi, all, I have a userform with 5 input fields, four of which are textboxes (the other is a combobox). Two of the fields ask the user to input a date in the format dd/mm/yy, and one of them asks for a number. Currently, these values are added to the worksheet as text values, even though the...

Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...

Hi, I am hoping someone could assist me please. I am helping someone with a spreadsheet and they are wanting to flag dates at various stages. Essentially they are looking for two queries; - When 10 business days have passed column P (Closing date), column W (Selection Report finalised) will...

I created a userform that displays certain values within row of the active cell, as a quick reference in a lofty spreadsheet. Right now it shows all values as regular numbers (shows "1" instead of "100%"), even if the referenced cell is a percentage. Code below --- i want Label9 to show up as a...

Hi, I have a spreadsheet that will be used by other people and I have locked all the cells which contain formulae and conditional formatting so that no one can break my sheet. However, there are some columns which the user will free type into and they would like to be able to change the colour...

Having trouble isolating the time component from some .csv data I'm importing. The datetime comes in as dd-mmm-yyyy hh:mm:ss:000 format, I ran a replace to repair the colon separator between seconds and milliseconds. Now I just want the hh:mm:ss.000 component. I tried to simply reformat with a...

Hi Everyone :) I am experiencing an issue with a macro I created to help format some raw data sheets I have to deal with at work. The macro I have made is almost perfect, except I need the macro to detect the data range of the cells in use (as this changes with each RAW data file I receive) and...

I'm looking to make cell range C9:C56 the only cells on the sheet where I can allow users to format the cell while protected and be able to change the cell colors in that range only to their liking. So far, with the given code below, all cells on the sheet are formattable while protected. From...

Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...

Hey guys, this forum has been super helpful for me in the past so I registered to ask a question I'm not able to figure out on my own rn. I work for a credit card processor and need help formatting expiration dates for use in a gateway that requires them in a specific format. The original info...

Hi all, I have a problem with textboxes in userform. Basically i just want to display one cell with a timer inside through one textbox in my userform. In C2 i have a timer and the cell format is "mm:ss", so the textbox2 should display that cell in that format but it seems so complicate. If the...

I think this is a formatting question ( or could be something else and I'm just not seeing it). I'd like to display data as 1/x. So the numerator is always 1 and the denominator changes. For example: 200/ 1000 = 1/5 2/5 = 1/10 330,000/330,000,000 = 1/1,000 403,000/330,000,000 = 1/819 Thank...

Hello, I have a worksheet that contains a parent product in column A, a Catagory in column B, and part numbers in column C, and again in column D. The goal is to combine all part numbers in column C and D. Normally I would find and replace all " " with "," followed by a =CONCATENATE(C2,",",D2)...

I have seen similar questions asked but have yet to find an answer for my circumstance. I have a Name Range (CDate) where a date is manually inputted into an excel file. I was using that name range in a formula to see if I should hide or show a column header. They are name ranges as well and are...

Hello I am having a problem formatting data in excel, I am preparing this data to import into a database that i have created. the problem is as follows: the raw data i have is for multiple chocolate recipe's that are broken down into the following: Name of recipe weight of ingredients unit of...