format

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...

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