sign

I need a macro that groups rows that contain the '-' character (in column C:C) Not hide, the + sign in Data -> group.

Hi, I would like to be able to see the £ sign for when the code below is run. Please advise thanks. Private Sub CommandButton1_Click()MsgBox "Entered value is " & Worksheets("DATABASE").Range("A1").Value End Sub

Hi there, I have a spreadsheet for user info entries. This has been working successfully but something has just come to my attention... If a user enters something into a cell and starts off with a - (minus sign) or = (equals), Excel is expecting some sort of formula to happen and causes an...

I was asked to find out if this is possible, I dont think it is, I mean i can create laid out signs with adobe indesign merging my spreadsheet, but I was asked to see if it was at all Possible to convert it semi-auto or easily into a laid out sign just based off data entered. Thanks in advance...

Hi, I am using the If and then statement. =IF((D6+D7-C8)>=C8,0,(D6+D7-C8)). But when the amounts are less than C8 it should be giving me a zero but it gives me a negative #. When I flip the greater, less than sign it gives me the Zero, but then it doesn't calculate correctly if my D6 and D7 are...

Using Excel 2000 Hi, Data In columns C:P, R:AE are the result columns. I want VBA or Formula which can extract only 3 first sign "1", "X" Or "2" find in the each row For example... there are 14 positions of 3 signs "1X2" in columns C:P Search for 1st sign in the row 6 there is "1" in the...

Hi, Does anyone know how to group hide columns and/or rows so it shows the below +sign next to the hidden columns? I think it looks neater than just the standard highlight-right click-hide option. Am I right in saying it's highlight the columns - Data - Group?

I have a text field for example: There are 8% of people who wear red I'd like to extract whatever number is before the "%" sign. I got as far as =MID(AJ2,FIND("%",AJ2)-3,LEN(AJ2)) which kind of works but leaves everything after the % sign. I just want the number ideally. Also some of the...

I've looked around quite a bit and I can't seem to find any way to display a ≥ sign in the text (prompt) of an inputbox. ChrW(&H2265) doesn't work. It just gives me an = sign and the ansi/ascii character set doesn't include a ≥ sign so I can't just use chr() to get one either. I really would...

Hello, I am using excel 2003 and would like to know if the below formula has any issues with it because I keep getting the #Value ! error and I'm not sure why. Below is my formula. I want the first two to be OR which is why there is a + sign between the. and the others are all * for AND...

I am at a loss...I cant find anything online to help figure out why I am getting this error message. I have used this VBA code before (located below) and now when I try to use I keep getting this error and cant move forward. The website opens and I can sign in but the coding is supposed to...

Hope I posted this in the right spot. I am thinking for my factory of buying a tablet that has excel on it. I want to turn all of our paper copy sign offs into electronic copies. It would get rid of 8 binders full of sign offs. Has anyone done something like this? I half tried it out on the...

Frank here. I have a formula = then a symbol which is not a dollar or an S but looks like it. How can I make my keyboard make such a sign and what does it do and mean? Anyone help? thanks

Is there any way with data validation to restrict entry or leave the cell empty or with a sign if another cell has value. For example if cell p3 has any value Q3 is blank or has a minus sign Thanks in advance.

I was asked to find and replace pound signs with a percentage sign in a particular workbook. Rather than doing find and replace all, I want to loop through all worksheets in VBA and see if the first character in each cell is a pound sign, remove that pound sign and replace it with a percentage...

Hi, Please provide the VBA code for the following formula. =IF((OR($AB$7="NPI",$AB$7="NPI-Lite")),(IF(AL8="(C) Initiated","5%",IF(OR(AL8="(C) MRD Sign off",AL8="(C) L&R Sign off",AL8="(C) FTA Intiated"),"10%",IF(AL8="(D) SRD Intitiated","30%",IF(OR(AL8="(D) Requirements - HLA and ROM sign...

Hi all, I extracted a large amount of data figures. I noticed that the minus sign is facing the wrong way, and thus Excel is picking it up as a text instead of a number figure. For example, 48-. The correct way I want it to read is -48. What's the best way to reverse the minus sign? I'm...

Hi Hope someone can assist, I have an Excel book that has VB to email out when certain criteria is met. in this it will put into the body of the email the users email address, but I would like it to only to show FirstName.LastName (or to the left of the @ sign) This is the bit of the VB that...

Hi, I need to group multiple seperate columns. The issue is excel will not let me group seperate columns using the standard group feature. Is anyone aware of any kind of workaround to allow me to emulate this. Normally I would be able to press the + sign to expand and - to retract, I need to...

Hi all, I am having a table which is obtained from SAP. It has a column with numbers, which I want to work with. I just want to add an "=" sign in front of all the values in column E so that calculations based on that values can be done. Is this possible. (What I am doing now is, entering "="...