format

I did an update last month. I'm now having an issue where sometimes a column of formulas doesn't calculate if the column is formatted as text. It took a little while to figure out that the formatting of the column was the issue. Instead, it will just show me the text of the formula, which...

When i view my excel file, the dates are in dd/mm/yyyy format. When i click on the date, it changes to mm/dd/yyyy format. When i click on format cell, the format is dd/mm/yyyy. This is causing me trouble as i have built an excel processor app that is not functioning correctly due to this. Why is...

I’m trying to figure out how to filter 100k rows of data pulled in from a data connection. I’m trying to filter by part #s, but each part # could have anywhere from 1 order to 1000. So I’m trying to find a way that will return all orders for given part numbers. - sheet 1 is the data pulled in...

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

Hi Excel community! I have a table where I would like to be able to format the value of the [Process] column according to the value of the [Type_Cli] column, as shown below: Case [Type_Cli] is 'F' -> Format shoult be : "P000000000"; Star with Letter 'P', followed by nine digits' Case...

Hi Everyone, I hope I can find an answer in this forum :) I'm working on formatting 20 finance tables in Excel for Mac and want to create a system for future use. The goal is to make it easy for our finance team to format tables consistently. So I've formatted a table with various styles...

So the issue I'm trying to solve: I have filtered a bunch of rows by color. While they are filtered, I want to format the style of only those filtered rows, or copy one of those selected rows onto a bunch of the other selected row. For example, I want to change to color of those rows and the...

Hi all, I would like to color the diagrams "Result" automatically according to the specified color. However, the diagrams should be based entirely on the arrays and adapt themselves completely dynamically. --> For example, if I add "Spain", Spain should also be added in the color green in all...

Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...

Hello everyone, I am new to writing in the VBA and have been using the WorksheetFunction.Text() command to format data. The data I am using is taken from PowerBI and for some reason my text function will not work correctly. Sub FormatAsText() Dim cel As Range, rng_percent As Range...

Greetings Excel Community, Below I have some Test data where the Unique ID has a relationship with the "Value" column. For each UniqueID, there must be a corresponding row from the "value" Column. What I am trying to accomplish is a formula or VBA Script that will split the UniqueID into its...

I have a column as ZIP code based out of USA that can have maximum length as 5. If I give 11, then it can take 000 as predecessors and become 00011. I tried formatting cells option but that has options to make it 0011 or 000-11 or 000000011. I am not getting options to make 00011. Any leads on...

Good morning, I'm making a spreadsheet to keep track of our leagues win/losses and stats. However, I think I'm formatting it incorrectly? The problem I'm having is if I try to filter it by home team, it won't show me the the same team when they're the visiting team. ex. I want to see all of...

I need to cut a long column of cells (millions) quickly. The current data displayed in the cell its date and time, displayed in a custom format of dd/mm/yy hh:mm I need to quickly cut this in a new column that only contains the hour. However, the MID function isn't working for this: . I have...

Hey Experts, Please can I get some help ? I have a lot of excel in different folders and each excel has a tab of test cases, in each cell of excel there are steps and that I have made changes by striking out with red font and added relevant text in red. Now the review is done and they want to...

Hello I have a Userform that I am using to enter data into cells in a row. One of those cells is to include a date. I want the date to be formatted "YY-MM-DD" (January 5, 2020 = 20-01-05). When I have the value from the userform entered into the cell it does not act as the date that it visually...

I am trying to use a basic formula D2+E2, but it wont add the time right. It should say 2:07 for time stop. (2:07+00:00) but it says 7 minutes. Any ideas why?

Hi there, I have a column with a mix of letters and numbers in each cell and I need one specific number to be subscript, even when there are other instances of that number present (e.g. I need the first 2 in H2-2 subscript but everything else normal case). I tried to target the first 2 by...

Hi, I have multiple data sets in columns A-G of 13 rows each, which are stacked on top of each other. The data sets are dynamic and there can be between 1 to 40 sets of data. The cells in the first row of the whole data set are headers. I currently have a macro that draws this data from the...

Hello Excel Community, I have a weird request which I am hoping someone might be able to provide a solution. I have rows where dates are provided in the following format yyyy-mm-dd and contain multiple dates in that format (Example: 2023-04-062023-04-072023-04-08). What I am trying to...