format

Hello, I'm trying to use the textjoin function to combine multiple dates into one cell and ignore blank cell. I was able to get to work using this function =TEXTJOIN(",",TRUE,D8:P8) but it brough the dates over in a number format like 44655, 44683, 44718. I want it to look like this 4/4/22...

Hello, i was curious if there is a way to use VBA to change to format of a cell(s) from accounting to custom type 0% Saying i have a sheet 1, cell D15 and D16 these are both accounting but wanting them to change from that to custom 0% thank you!

Hello, so when I download this sheet from the web, it always shows this error "Convert to number", basically in few of columns (where there are numbers) it is stored as different format which does not allow you to sort with number and mathematical operations, I change it manually with...

So since friday my excel is acting up. If i try to decrease/ increase decimal this happens If i try to change a cell from general to number it instead moves the decimal point two steps 1.234>>0.01, 12.34>>0.12 etc. If i change my system comma separator from dot to comma everything starts...

I have the following spreadsheet with about 2000 rows, ABCDEFGHIJKLMNO1Ref No(s)TitleEff DateATAComments2TEST 1B737 ADVERTISING PLACARD INSTALLATION25Referenced By: TEST3ParagraphMethod Of ComplianceRLifeLast ComplE/D O/RideLimit/ IntervalF/ LNext DueRemain4Initial Issue...

I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop. is there something I can do to get them...

Hi all, I have the following setup (albeit in a much larger setting with multiple lines of emails): I want to merge my emails in A121 and A122 into one cell, like I have done above in A120. Is this possible? In reality, I need to do this for about 50-100 rows of emails from column B-T...

Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...

Hello, I am trying to Highlight multiple cells based on a specific cell. If cell K32 = True, I want cells B2:G239 highlighted in one color and if K32 = False, then no change. I have tried the following with no luck: Thanks in advance for any assistance!

hello, community. I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel. at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only...

Hey hey people. I need to use the Format function to change some raw numbers like "123456789.123456789" to either be "123,456,789" or "123.456.789", depending on the language a user selects when activating my macro. I found some code online from Formatting Numbers in Excel VBA - Automate Excel...

Hello, I have a file with 2 sheets Named: Holiday Calendar ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ120222BHBank Holiday UK&IBHBank Holiday UKBHBank Holiday IrelandHoliday34January5Carried FwdIn LieuEntitledLeft...

I have a column that the user wishes to have a simple calculation (H11-M11) as well as having a % in the same cell. Formula is ::: =(H11-M11)&" / "&TEXT(H11/M11,"0%") If the first part is negative, I wish for it to be RED. If not, then GREEN. Does someone know of a code that allows this...

Hello all. I have a situation that is driving me crazy. First off, I am using excel in Office 365. I have a workbook in which I export data out of SAS tables into different sheets. I have a main sheet where I use MS Queries to pull that data in from the other worksheets in the workbook. I...

I am very new to VBA so I apologize in advance if this question and code is a bit amateurish. The code I currently have is Function CUSTOMSTYLE(TargetCell As Range) TargetCell.Copy ActiveCell.PasteSpecial (xlPasteValues) ActiveCell.Font.Color = RGB(255, 0, 0)...

I have a Scatter plot with 16 different series, 8 have Markers with no lines and 8 have lines with no markers. The data displayed comes from a TABLE, and I use a series of SLICERS to filter the plotted data. Occasionally when turning on and off buttons in a slicer ALL plotted series are...

Hi! First time posting here! I have been struggling with a very specific and probably weird issue that I am not sure of having a solution. The problem is related to text that is initially in word documents. Likewise, I have today asked for advice in a forum connected to Word VBA...

Hello, I have to vlookup some values in a table where the lookup column has rows with text and rows with numbers stored as text. In order to get the right formatting so that the lookup works, I use the following formula that converts "numbers stored as text" to numbers and ignores the text...

>10k of rows of short sentences have within then, usually, a code. I need to extract this code, but how do I get PQ to recognise its format, which is: 230F-115-04 301F-115-05 30A-115-26 30F-1180-02 30F-118-03 30F-1252-04 130H-1252-05 30F-1252-18 30F-126-01 40G-127-01...

I have a report that gives the time as "8/19/2021 12:26:01 AM -04:00", but I need the " -04:00" part to be taken off. Is there any way to custom format or integrate a formula within that custom format so this would be the case? I want to avoid altering the spreadsheet otherwise. My alternate...