format

I have a spreadsheet that is generated nightly by our ERP system and I think the timestamps are being entered in 2 different way, or something? When I try to pivot the table, I can't group the time nor sort it by time. I've tried every different time format but nothing seems to work. I think...

Hello, What I am attempting to get help with is creating an automated power query (as in using a macro button to initiate process) that loads and transforms the source file into a usable and repeatable format. Below, I have attached a picture of the source file so that you can see what it looks...

Greetings Excel Community, I have numbers formatted in the following Text or general format: 20221026.. I am trying to format it as mm/dd/yyyy.... I have used a formula as follows but it is not generating the correct output: Formula is =DATE(LEFT(G2|4)|MID(G2|5|3)|RIGHT(G2|2)). I am including...

Earlier this year I was able to create a custom number format such that whenever I typed, for example, three pairs of numbers altogether: 112233 or 095543 or whatever, any combination then the outcome would always be, using the above two examples: 11:22:33 or 09:55:43 which was to signify...

Hi Team, I want to validate my inputs so no unnecessary data will be entered. Please show me how. Date Rego# (eg:ABC123): 3x ALPHABET & 3x NUMERICALS Time Out & Time In. Date Rego# Driver Name Type of Vehicle Trip remarks Load remarks Destination Time Out Milage- Out Time In Milage- in...

I've got code here that will bring in information while looping through workbooks in a folder. It could be 5 workbooks or 50. Usually on the higher end. I'm bringing in 5 rows of information so every time i open a new workbook for information, i need it to go down to the 5th row and start again...

Hello Everybody, I wanted to change the decimal number (NOT CONVERT) into showing feet and inches using custom cell format. For eg: 1.If the decimal number is 5.9 then using custom cell format i wanted it to show 5'-9". 2.If the decimal number is 12.11 then using custom cell format i wanted it...

Hello, I have a Excel sheet in which dates are in this format : YYYYMMDD without "/" separation, So I used "Record Macro" - DATE -> Convert to change in to this format : DD/MM/YYYY, here the code it got me out : Range("A5", Range("A5").End(xlDown)).Select Selection.TextToColumns...

Hi, I'm using conditional formatting and for all of the ones I have used (equal to and contains) when i removed the text it leaves behind a half border like so: It stays there unless I go into the formula line and press enter. I would like it if it doesn't do that. Does anyone have any tips...

Could some one explain why cell W3 is counted as a number, yet W5 is not? both are formatted to [h]:mm I potentially get data ranging from 00:00 to 9999999:59, but ISNUMBER seems to stop working at 9999:59. Any help with this...

I am really struggling with the formulas for one particular cell. What i'm looking for is the value in B17 will be determined as Followed. I'm hoping someone can help my brain wrap around this IF b15 is less than 50, then b19= "Product A" IF b15 is greater than 50, and less than 250, then b19=...

Hi everyone, Trying to get the average processing time of coloumn K but I get a #DIV/0! error. Does anyone know what could be wrong? Both coloumns are formatted as TIME values but K is still text when using =ISTEXT. Formula =AVERAGE(K2:K10) I get a #VALUE! error when using this formula...

Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...

I wanna change the font and size of the entire left header and make part of that header Bold. Since this doesn't have a cell reference I'm having difficulty trying to figure out how to do this. Advance Thanks for all the answers. Note that the header info is being fed in using a userform to get...

This is my full code Sub StripData() Call InsertData Call FormatData 'Call DragData End Sub Sub InsertData() Dim myWb As Workbook Dim myRowsToCopy As Range Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw") Set formatrange = Range("B2:CE2") Set formularange = Range("AK2:CE2")...

Hello, Can someone point me in the right direction for applying data bars to a bi matrix, it seems like I've been through every drop down menu ; Grid , Values, etc and I can't see anything, I've looked at one or two things online but they seem to be out of date as the menu's are not the same as...

Hello! I am using VBA to send out emails containing a text body made up of bullet points with varying lengths (using the code from smozgur in this thread: Use VBA to enter a varying range of bullet points into body of email). Which creates a reference to the bullet list in the body text instead...

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