general

Hi folks, I wonder if anyone knows a way to determine if a worksheet is protected WITH a password vs. protected without a password. I know how to check for protection in general...but not how to figure out if there's a password attached to that protection. Any insight/direction is greatly...

Hi everyone, I declare a variable as variant. The input for the variable are mostly strings and some scientific numbers. The Selection.Find keeps giving errors whenever it tries to find a scientific number. I formatted the data in the search row as "general". Below you can find part of the...

Cell fomat gets changed automatically from General to Date.

I was hoping for assistance with flagging a sheet of duplicate emails. Below are considerations and matching criteria: There can be 2 rows of the same email, or 3 rows, or 4 rows, etc. The first criteria that should determine which row gets flagged is the higher the General Number is, that...

I have the following code, which simply opens workbooks that are all in the same folder (this is the source). the code then copies a range on the General worksheet within each of the workbooks. The range is then pasted to the destination workbook (the one with this code). All of the workbooks...

I have a formula that returns a number 1,3,4 with the following =IF(E3=D3,"",(IF(E3="R","3",IF(F3="R","4","1")))) I want to highlight values of 3 and 4 but I cant seem to get the conditional formatting to work. I have played with the format of the cells making them numbers, texts, general, etc...

Hello, I've searched several threads but I couldn´t find one that could help. I'm trying to find a formula and a VBA function that is able to return the location of a string in a sheet (A) and also within a restricted area (B). This is what I want for each Output (A and B) with 16.03 for...

Guys, i have a simple code: With Rows("3") .Replace What:=",", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _ ReplaceFormat:=False End With The goal is to change the regional settings. I want to get rid of ","...

In Excel, I want to format a number as "General", together with commas to separate multiples of 1000. The current General format excludes the commas. For example: INPUT: 1245.32 SCREEN OUTPUT: 1,245.32

I have a column of approx 350 entries. Generally the data is as follows <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}td {padding:0px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none...

Hi guys, I'm having this weird issue in my spreadsheet. I have columns populated with fractions but in excel they are not yet selected as fractions (They are "general"). When I select them and change the data type to fraction, it says its a fraction but there is no change. When I individually...

Hi I'm learning about splitting and joining. I have a cell, which is a dose response of concentrations in scientific notation. I have got to the step where my array is filled with each concentration. I now need to change the format from 1.0E-6 to 0.000001 I've attempted: WrdArray(i) =...

Hi There! I need some help to sum up the value for drop-down list. Each item in the drop-down list should have a value tagged with it. This is the scenario: <colgroup><col><col><col><col><col><col></colgroup><tbody> Subject Name Type Status Appointment ID Time...

Hi I have a data column that shows a series of level 1 and level 2 tags. the data presents as L1 space and then the name of the level 1 tag then a comma space then L2 space and the name of the level 2 tag. See examples below I urgently need a formula that returns the L1 tag name and a second...

Hi Experts, I tried to enter (0001,0001) into an excel cell. The excel displayed the value as -10001. The cell needs to be "(0001,0001)". Any idea? Thanks a lot!

I have 3 columns Column A has a general number ie 1 for January Column B has a general number ie 10 for tenth day of January Column C has a general number ie 2017 How do I get column d or e to combine 1/10/2017 to represent January 10, 2017

Excel 2007. Cell A1 : contains income in numerical, for example 1500000 Cell B1 : contains category in text. The text will be either GENERAL or SRCTZN B1 will display only GENERAL or SRCTZN. Cell C1: contains formula to calculate Tax for GENERAL category. Cell D1...

we are going to a new pay system. Instead of just a standard hourly wage, employees will be able to make a higher wage based on the production of the plant they work at. I am looking for help with a formula that will assign the new wage per hour based on the level of the employee and the amount...

I'm vaguely familiar with the INDIRECT() formula, but not enough to solve my problem. In my Worksheet Named MAIN I currently have the formula (WHICH WORKS!!): =SUM('Aug 2017'!K25:K28) I was to modify the above so that I can reference in the 'Aug 2017' portion using another reference. In my...

Hi gurus, I am trying to put together VBA to search for a specific cell format and then change that cell format. The cell formats I am wanting to replace are the variety between "< 1" and "< 0.00001" (formatted general); I want to replace them with proper number formatting ("< 0", etc.)...