general

Hi all, I'm importing a .xls file into my own file. Basically I'm copying one sheet, and one of the columns has dates. The values are in general format (example: 1/14/2019 3:24:51 AM) and in US format. I need to change the format to date (without the time) and to Europe format so I can make...

Hi, I have data where by the row is dates and there are multiple columns underneath with data in. I wish to count the number of times any entry is not blank for a whole month. So for Nov, the answer would be 14, Dec would be 17 I used COUNTIFS(A2:A7,"<>""",INDEX(B2:H7,,MATCH(M4,B1:H1,0)),">0")...

Custom Formatting is driven by the format code (E.G. #,##0, etc). When I look in the format dialog box I don't see a code for "General" - it just says general. I'm curious, what would be the custom code for General - does anyone know? I tried to google it but couldn't find anything specific to...

Hello Genius, Kindly help me on the below requirement. Actually I have data in the format of "General" which has Date & Time in that. I need to convert it to Date format. From : Dec 5 2018 2:46PM to : 12/05/18 or 12/05/2018. Your help is greatly appreciated ! Thanks.

Is there one formula that could be used in all of column B to convert data that looks like the data in column A, into column B? Column A's current format is General. The resulting format of column B can be Date, but does not have to be. If the Length of column A were consistent, I would not...

Hi I want to set up a general general RFQ compiler using Excel. I would start with a table and manually input part numbers. Then I would use a macro to input suppliers and prices. There could be 20 parts in total but some suppliers might only be quoting for 1 or 2. I am thinking of using...

I have a report that is giving me times in a general format where instead of giving me 12:18 AM it appears as 18 and so on and I want to subtract one column from another, but my issue is when doing so I am not getting a time rather just a general number. For example cell C2 has 18 (12:18AM) and...

Hi everyone, When I export a report i get a list of percentages in a "General" format. When i change the format to "Number" it does not appear to act as a number, meaning I can't sum it or select cells and it provides the sum in the bottom of the status bar. Any help would be appreciated. I...

Hi I’ve just registered on this site so apologises in advance if my post is incorrect in any way. I need some help : I have a list of postcodes for a particular county (wanted list) I have another list of random postcodes from lots of different counties (general list) I need to identify how...

Hello, I have data in two tables, and I need to apply conditional formatting where the data matches and where it differs. For example: if I have a business that has 2 general managers and 3 assistant managers (table 1 - this data will change), and they should have 1 general manager and 5...

Hello, I have data in two tables, and I need to apply conditional formatting where the data matches and where it differs. For example: if I have a business that has 2 general managers and 3 assistant managers (table 1 - this data will change), and they should have 1 general manager and 5...

I have an issue where a report shows time in the format hh:mm:ss but has been saved in general format and I can't sum these, how can I resolve to get a sum of time? Thanks

Hi I need Program for convert formula into general value But for other sheet . I having the below program but its working only for same sheet . But i want run the below program for Sheet2 from Sheet1 Sub Convert_To_General() Dim vData As Variant vData = Columns(9)...

I have a dilemma that I can't resolve and can find no relevant examples. I have two tables with Class mnemonics (pharmacologic/therapeutic classifications) listed in the general format - 00:00.00. when I download a report containing this information some are formatted as custom but with...

I ran into another issue while trying to solve something else. I have a table of subcategories and general categories that i would like to be able to match to as close as possible to the general category. There are two parts to this issue. One is that the cell where the table will be matching is...

Hi can you show me how you construct financial model I havent got a clue :( <colgroup><col><col><col></colgroup><tbody> Modelling Skills We have 12 new sites coming on over the next 34 months (starting Feb 18 and finishing in Dec 20). We need to create a model to calculate our...

How can I restrict cells to allow only alphabet character entry only? I cannot figure out a possible formula in Data Validation and formatting the cells to General or Text allows other non-alphabet characters. Thanks in advance.

Hi guys I have general column with data that represents date but the format cell type is general I want to convert that data to date format. The problem that I am facing is excel by default puts wrong date considering the Jan 1990 start date. Example : want to convert 40317(general cell...

I got dates on excel in general format form. I want to format them to actual dates. I tried formatting them as dates but they stay the same so it doesnt work. I read about delimiter but I tried it and that doesnt work either or maybe I'm not doing it right. ANyway here are the dates: 31.03.14...

IF((or(C5="Dollar General",R5,0),(c5="Family Dollar",r5,0) or(c5="******* Barrel,r5,0)or(c5="Reserved",r5,0))) Basically have a list of stores in C. I need it to pick up the following stores and if true want it to return the amount is col R Dollar General Dollar General - SBT ******* Barrel...