sign

So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative. Website value: –0.13% Regular value: -0.13% I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste...

When I copy/pasted a suggested macro into a response to another forum member, the macro contained a 'pound' sign but when pasted into the response, it came out as a question mark. Is there a way to have it pasted while keeping the original format?

Hi, I built a table (PriceTable) that keeps pricing based on volume ordered as follows: ColumnA ColB ColC ColD 1 ProductName Sign Qty Price 2 ProductA > 10 $3 3 ProductA < 10 $4...

Hi I have excel at work and we use the office 365. Is it possible for me to sign up to be an office insider does anybody know because I can't work out what I need to do and if it is even possible? Cheers Joe

Good Evening.... I have a column with dollar amounts, as such, for example " $21.85. Any amount with a zero at the end will not show when I do a drop down list at data validation. For example...$18.50, will show as "18.5". I do not care about the $ sign, but I need that zero at the end. I have...

Hi I do not understand why excel multiple a number by 100 before adding % sign. Thank you so much. https://www.extendoffice.com/documents/excel/850-excel-add-percentage-sign.html

I only want to show dates before 12/01/18. How do I do this? This is my pivot table data: Vendor and Next Step Number of Invoices Total Amount Sum of Field1 ANS Distributing 4 1102.52 0 Emeka to Sign 4 1102.52 0 11/21/2018 2 466.74 0 11/26/2018 1 296.95 0 11/28/2018 1 338.83 0...

Hi I was reading one of Mike Girvin's document and he said the following: ++ Accounting Number Format: Fixed dollar sign (left edge of cell). Negatives are in parenthesis. Zeros are dashes. Decimals always line up. Currency: Floating dollar sign. You choose how to show...

Hi there, I am confused because when using the Accounting number format with the € (Euro) currency, negative numbers appear with the "-" sign at the very left, before the € sign, as in this example, whereas when using the Accounting number format with the $ (Dollar) currency, negative numbers...

Hi all, Can we use $ (dollar) sign in defined names, for example: Total_Invoice_$ or Invoice_$total ? Thank you in advance

Hi SAP accept negative values with "-" sign on the right. what would be the formula when moving negative sign from left to right. I am usually seeing from right to left. TIA!

With the help of the forum I have a signature macro that had been working fine, but recently has been putting the signature of the person that last opens it into the file (suppose to be the signature of the person that performs the recon) Below is the code that I have ben using (work sheet...

How would i make this a number when these zeros can change to a non-zero number... I'd also like to delete the + sign.. Thanks.. <tbody> 0000001255965+ </tbody> <tbody> 0001366158900+ </tbody>

Hello, I've inherited an Excel macro at work that I need to update. I am somewhat familiar with VBA but far from being an expert. Here is a snippet of the code I would like to ask about: If Len(bad_data_temp) = 0 Then bad_data_temp = arr1(i, 1) & " in row " & i & "@@@@@Range(" &...

I am making a spreadsheet to track auction results. I need to find out, of the total buyers, how many are club members or visitors. I have a sign in tab that identifies each person as m or v and gives them a bidding number. Another tab has auction results, who bought the item(using bidding...

Hello, We have a form that our buyers use to fill in data that we then save a .csv and import it into indesign and create a sign based off the entered criteria, everything goes to where it should yada yada. I want to know if its possible based on the entered criteria to show a sample sign to...

There are 2 columns Debit and Credit both with positive sign. I need to put numbers from Credit into Debit Column with sign "minus". <colgroup><col><col></colgroup><tbody> Debit Credit 1250000 140 140 140 140 </tbody>

I have data in a cell of 1 to maximum of 10 numbers with + sign in between them, but they can not be added as yet for they are part of a string. How would be the formula or the function for its sum? example: Column A Column B...

First of all here is my function; =IF(A7<>"",IF(COUNTIF($A$7:$A$33,A7)>1,"0.00",$D$4),"") This formula pulls adds a fee (cell D4) when you sign in, and SHOULD allow a sign out and not add a duplicate membership fee. This is meant for column B, is it blank when the parallel cell in column A is...

required formula or macro for joining column2 with column 1 1.if + sign is not there then join as it is with _ 2. if + sign is there then join after first + sign length is not fix <tbody> column 1 column 2 required AAAAAAA 6 AAAAAAA_6 AAAAAAA+BBBBBBBBBBBB 2 AAAAAAA_2+BBBBBBBBBBBB...