sign

Hello, hoping someone can help me with this Excel VBA question. Column T is the sign off column. In order to sign off, Two cells are Mandatory. 1. If column L contains ICP, then, Column O should have a trading partner. 2. Column N should have a Text. Thank you.

I need to add a minus sign in front of a number in cell G8 and one in H8. Thank you for your time

I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So...

I have recently been experiencing something I have not seen in my fifteen years of working with Excel: @ signs are appearing in my workbooks formulas directly after the = sign. For example...

Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe

Hi All I know how to insert characters x spaces from left or right, but in my column have a list of email addresses.They are all completely different and vary in length an characters before and after the @ sign. As an example I would like to change fred@smith.com to fred-123@smith.com and...

Hi, I have a template that calculates costs for services per month based on input from managers. I have set dot/"." as default decimal sign whilst everyone else have comma/"," (applies to all excel files you open). Due to this, they can not see the calculated costs for rows that contain cells...

Hi can someone help please I have the following VBA code which is in my worksheet 3 known as “IN” and what this code does is basically cuts and pastes the cell content under column A from my “IN” sheet and pastes it into column C in my “OUT “sheet, but because the “OUT” sheet 4 has a “ - “...

Hi I want to insert a formula in the cell left to a check box, if the CheckBoxes.Value = xlOn : Sub test() For i = 53 To 102 If ActiveSheet.CheckBoxes(i).Value = xlOn Then ActiveSheet.CheckBoxes(i).TopLeftCell.Offset(1, 0).Formula = ("=2+2") End If...

hi im scanning barcodes into A column and want b column to put description of item in column in B I am trying to create a inventory sign out, sign in page for search and rescue Thanks Barry

Hello! I have merged cells A1-A3 and I want to drag this and merge B1-B3, C1-C3 etc. However, dragging the + sign copies also the formatting, not only the merging. Is there a solution? Thanks!

I have 1700 hundred record some are debit and some are credit I need to move credit value in debit column with negative sign as value

Hi, I have a formula that says =if(A1>A2,"True","False"). However, I want the ability for the user to change the sign in an other cell. So let's say in cell B1 they can enter ">" or "<". I want to write a formula something like this =if(A1&B1&A2,"True","False"). This does not work. How can I do...

[<=1000000]#0.00,," K";[>=1000000]#0.00,," M";0.0 Hi Folks. What would I do to make this custom format display a $ sign followed by one space prior to the number? So instead, for example, of 5.21 M it would show $ 5.21 M. Thanks in advance for your time!! Best, Aimee in Madison

Hello, I am filtering column A (the only column in the sheet) for all rows that begins with an @ sign. The delete all rows that do not start with an @ sign I have some code which does this OK. However I also want the filter to return the row directly above the one found with the @ sign. And...

Hi all, Any advice would be appreciated on this! Column P of my workbook is a numerical column and Column Q is a Currency sign indicator, I need to add the Currency sign indicator to the front of the cell in column P or at the end depending on the currency sign indicator. £ = UK Pounds P =...

I would like to create a custom number format where millions are displayed as thousands. I know the formula for that is #,##0,;-#,##0, My problem is that I also need to add an accounting offset dollar sign. So I need $ 1,000,000 displays as $ 1,000 with the dollar sign in the same position...

I have a large excel spread sheet with the following characters repeated: (CD #####). The #### are replaced for different situations. For example one instance might be CD 1-1 or CD 13-5, etc. I have seen that there are VBAs that can be used to color texts but I am looking to HIGHLIGHT the...

hi, I need a "if" formula with below case in cell A1 i have amount 55000(positive), in cell B1 I have sign "+". similarly, in A2 i have amount -25000 (negative) and in cell B2 sign "-" . the signs +/- are manually input based on requirement.. now the formula should tell me if the amount in A1...

hi, I need a "if" formula with below case in cell A1 i have amount 55000(positive), in cell B1 I have sign "+". similarly, in A2 i have amount -25000 (negative) and in cell B2 sign "-" . the signs +/- are manually input based on requirement.. now the formula should tell me if the amount in A1...