Currency Sign
I have a very frustrating problem with my business plan i am writing in Excel. every so often it crashes and when I open it again all the £ signs have turned to $ signs and i have to go through and painstakingly change them all. This also happens even if I just close the file carefully and open it up again. I have tried looking in preferences to see if there is a default setting but can't seem to work it out. can anyone help me with this tiresome issue?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Currency Convertor ($ Sign Doesn Not Appear)
I have a spreadsheet with cells defined as Euro & Dollars. I want to add an automatic conversion so for example, if a cell is defined as $ the formula will return the sum X 4 and if it is Euro than sum X 5. I tried to use "if" combined with "search" (so if the cell contains "$" multiply by 4) but since the cell is defined as currency the $ sign does not appear and cannot be searched…
View Replies!
View Related
How To Separate The Currency Sign From The Number
I have a file contains thousands of rows of purchasing order. the purchasing value is in different local currency,the data(number) format is "Accounting" . Is there a way to separate the currency sign and the number into different column? I need to the currency sign to be able to convert data to desired currency. But Excel read the data as number. so I was doing it row by row. Such a pain and not efficient.
View Replies!
View Related
Concatenate Formula Not Taking Decimal Places/currency Sign
i have lets say a table with rows that contain the following data. SKU - PRICE - SALEPRICE - DESCRIPTION - SALEDESCRIPTION What I am trying to do, is to make a concat formula that says: SALEDESCRIPTION = DESCRIPTION+price was+PRICE+now+SALEPRICE In essence so that i can simply pull down the formula, and all our product descriptions have 'special offer, was xx (price) is now xx (sale price). This works fine, except that in the SALEDESCRIPTION, the amounts from the price and saleprice fields are being brought over without decimal places and without currency symbol. I have tried formatting those two columns as currency or accounting but neither works.
View Replies!
View Related
Decimal Sign Replaced With ';' Sign
I'm trying to solve a strange problem in a piece of code. I have a variable that is define as Double called STD. When i try to insert that variable in a formula the decimal sign (for me a comma "," because I'm Portuguese) gets converted to ";" (which is for me the separation sign for the expressions in excel formulas. ex: AND(A1>0;B1>0)=TRUE). The code is:
View Replies!
View Related
How To Remove = Sign
looking for a formula to remove an "= sign" at the very beginning. hence if "=Jordan" then want to change it to "Jordan" in cell T3 only. but wait, the resulting cell T3 "=Jordan" already has a formula inside it =(U3&V3&W3&X3&Y3) How to enter formula for removing "= sign" and not disturbing the existing formula ....
View Replies!
View Related
Special Sign Removal
I got three columns in excel. Column A is a list of items, so is column C. Column B displays the similarity in the 2 lists. I use the following command =IF(ISERROR(MATCH(A1,$C$1:$C$265,0)),"",A1). SO: A B C Cat Fish Dog Dog Roll Bull Carpet Apple Dog But what I want to do is the following: If I have "D-og 12 2-3" in column A and say "do g 1 22/3" in column C, I want it to be displayed in column B. To do that I need to decapitalise and remove all the special symbols such as space, ), (, *, &, ^, %, $, #, @,! etc. So I get dog1223 in column B since they are the same.
View Replies!
View Related
Extract The Numbers Following # Sign
This should be an easy one but I am having a difficult time extracting the digits after the # sign in each account description in my list. The values in each cell do not follow any rhyme or reason and differ in length. Three examples of the current data and what I am looking to extract are below. Current Data: ALBERTSONS #8272-ROSEVIL WHS-closed ALBERTSON'S #703 - SAN RAMON ALBERTSONS #7105 - CARMEL (SOLD 6/06) Extract Needed: 8272 703 7105
View Replies!
View Related
Place The Name Before Equal Sign
I'm trying to simplify a section of my code by naming a long string that is repeated. I tried by simply place the Name before equal sign (=) and also putting Set before the name. Both failed though I've seen both methods used successfully in other code. Am I having a syntax issue of some sort? Private Sub ConditionalRowDelete() Dim NumRows, iLine As Integer ActiveSheet.UsedRange.Select NumRows = ActiveSheet.UsedRange.Rows.Count Dim CircuitType As Range Set CircuitType = Range("C" & iLine).Value For iLine = NumRows To 2 Step -1 If Range("A" & iLine).Value > "6999" Then Rows(iLine).EntireRow.Delete End If Next iLine For iLine = NumRows To 2 Step -1 If CircuitType = "VOIP" Or CircuitType = "Customer Care" Or CircuitType = "Dialup" Or CircuitType = "IRU" Then Rows(iLine).EntireRow.Delete End If Next iLine End Sub
View Replies!
View Related
Plus Or Minus Sign In The Beginning?
I want to save phone no as +99 9876543210 in excel 2003 on my xp pro machine. But if i give a + sign in the cell, some blue dotted rectangle shows up and everything messes up.. I think it is treating it as a formula or something... how can i save this in the cell. tell me in detail if you are going to tell me about macros or vb code as I don't know how to insert code or program macros.
View Replies!
View Related
Prevent Copy From Using $ Sign
Get a SUMIF formula to work, which it now does, but the formula puts '$' signs in the range, so that when it copies it, it does not change the range. I have got round this, by defining 12 separate ranges. But it does make the code rather long winded. Anyone know how to put the formula in without the '$' signs? There must be a way to put the formula into the first cell, and copy it across? Set Rga = Range("b6") Set Rgb = Range("b6").End(xlDown) Set Rgd = Range("$e$6") Set Rge = Range("$e$6").End(xlDown) Set Rgc = Range(Cells(6, 2), Cells(6, 2).End(xlDown)).Offset(0, 3) Set Rgh = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 3) Set Rgi = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 4) Set Rgj = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 5) Set Rgk = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 6) Set Rgl = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 7) Set Rgm = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 8) Set Rgn = Range(Cells(6, 5), Cells(6, 5).End(xlDown)).Offset(0, 9).............................
View Replies!
View Related
Entering $ Sign (absolute Values)
I tried to make use of the indirect function but don't think this is the right type of formula to be used. Essentially in column A..i have linked cell references e.g = D2767 However, for the whole of the column I'd like to change the refs to =$D$2767, ALL in column A in one go. I know that if you place the cursor in one cell immediately after the = sign and press F4 it automatically adds $ SIGNS TO THE CELL, which I find useful for V-lookups, but I obviously cannot do it (fill it) all the way down the column i'm using excel v7. In addition or related how would I write an IF formula to read eg. = IF (cell ref begins with C, then link and add PRECEDING AND FOLLOWING $ signs to all refs)?
View Replies!
View Related
Show These #### SIGN When The Sheet Is Printed
In A1 I have the time (military h:mm) 8:00 In B1 I have the 30 min braek we take at work 0.30 in C1 the end of shift time (16:00) In D1 total hours (formula : = sum(C1-A1)-B1 and it is OK EXCEPT if the employee has the day off. In that case A1 and C1 are empty but because of B1 I get in D1 the terrible #### How can I remedy this ... this sheet cannot be edited in anyway. ( I cannot delete or edit anything) Thought of an IF but the #### are not a value so I cannot do much in the way of conditional fprmats ... how not to show these #### when the sheet is printed.
View Replies!
View Related
Changing The Sign Values In Cells
i have one row of values ie c4="-121" d4="122" e4="123" f4="124" and h4="test" like this . if h4="right" (i change the value test to write) i want to change the c4,d4,e4,f4 signs positive to negative ie c4=+121 d4=-122 e4=-123 f4=-124 i write sample code like this
View Replies!
View Related
Copy Formatting Using Equal Sign
This seems simple... If I let A1=8 If I fill in the cell green, either manually or with conditional formatting, and then copy and paste the cell into A2, A2 is now green with the number 8 inside. However, if in A2 I type "=A1", A2 still has the 8 but is no longer green. Is there a way to copy the formatting of a cell by setting it equal to the original?
View Replies!
View Related
Display Plus Sign For Positive Numbers
If you have a formula lets say ( sum A1-A2) and the total is negative i.e. A1 is 100, A2 is 50 would return -50, how do you get the value to show a plus sign if the value is positive? i.e. if A2 is 100 and A1 is 50, excel would simply show 50, but I'd like it to show +50. Also, if the result is 0, so both A1 and A2 are 50, how do I get Excel to display the words On Forecast in a cell?
View Replies!
View Related
Sign & Sumproduct Functions
I have three pages of daily data I am working with; orginal source data, manipulated data, and my output. My output data is a daily row of six columns containing 1, 0, or -1, based on my manipulated data (1,1,0-1,1,-1). I would like by row, sum the coresponding source data (5,4,0,-3,3,-4) by the positve 1s and a second column with the negative 1s. then average the column by the number of consituents (positive5+4+3 )/3=4 & negative;(-4+-3)/2=-3.5)
View Replies!
View Related
Currency Conversion
I am working on a sheet that logs sales enquiries and quotations. The quotations may be made in either Dollars, Euros or Pounds. However, I want the 'reporting' column to be Pounds. I would appreciate any advice on the simplest way of achieving this. Imagine column A is dollars, column B is Euros and column C is pounds. Most of the time the quotations are done in pounds and the other two columns will be blank. Also, there will only ever be one figure quoted per row. Would it be easier to create a fourth column (D) to consolidate the three separate figures together? We are using fixed exchange rates for the year, so to convert to pounds we will multiply any dollar quotations by 0.5 and any euro quotations will be multiplied by 0.69.
View Replies!
View Related
Sign Flip Macro To Skip Blanks
I have been using this macro, which works perfect: Sub Signflip() Dim cell As Range For Each cell In Selection If IsNumeric(cell.Value) Then cell.Value = -cell.Value Next cell End Sub It allows me to select cells and flip from neg to pos, pos to neg, and it won't error out on text cells. Great little macro. However, I don't like how it puts a zero in blank cells. It slows down the macro when I select large areas. Is there a way to make this macro work the same way but skip over empty or blank cells and not enter a zero.
View Replies!
View Related
Pull Text After @ Sign In Email Addresses
I have a worksheet with a column that contains about 30k email addresses in the following format: name@company.com I would like to make a macro to do the following: I would like to pull the company name out (the text after the @ symbol) and put it into the next column, but it needs to remain with the email. I would like to do this with all of the emails on the sheet. before: john@doe.com jane@company.com after: john@doe.com doe jane@company.com company
View Replies!
View Related
Format Currency In IF Statement
I am having a problem defining a currency format based on an IF statement. My statement looks like this......... =IF(E22=1,"USD",IF(E22=2,"CAD",IF(E22=3,"EURO","USD"))) What I want is to show $ when USD or CAD is returned and € when EURO is returned.
View Replies!
View Related
Spell A Number (not Currency)
I am using Excel 2003 and have a column within my spreadsheet that, through a formula, inserts a decimal that has formatting to show as a percent. I would like to know who to convert that number to words. I saw spellnumber (and love it!) but don't know how to edit it so that it converts properly.
View Replies!
View Related
Format Textbox For Currency
I need to be able to format a textbox as curancy. Simple enough, right? The problem is that this box is loaded from two sources. The first is automatic using the change event, this works well. The second is to enter directly into the textbox, which requires using the exit event, this also works. The problem comes when I try to use both events. The change event interfers with the direct entry (the format keeps changing the entered value and will not allow the user to finish entering). Private Sub TextBox1_Change() TextBox1.Text = Format(TextBox1.Text, "$ #,##0.00") End Sub Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) TextBox1.Text = Format(TextBox1.Text, "$ #,##0.00") End Sub How can this be changed to work for both aut load and direct load?
View Replies!
View Related
Live Currency Rates
I know that Excel has a function to import currnecy rates from the MSN Money web site. But MSN Money doesn't support all currencies. I would like to build an excel sheet where a user can maintain the currency codes and the currency rate is being fetched from the internet. Does anybody have a suggestion from where I could get currency rates into Excel?
View Replies!
View Related
Automatic Currency Conversion
I'm using excel 2000 Is there anyway to format cells such that I can enter values as Euros and they automatically convert to £ eg If I enter 14.60 (Euros) it automatically displays as £10.00, my conversion rate of 1.46 is constant throughout I know I can do the copy paste special divide thing but the above would be a much nicer solution
View Replies!
View Related
Text Representing A Currency Value
I am a complete newbie at Excel, but trying to set up a simple worksheet that I can use to save a lot of time. I have a list of names and each has a paper delivered each day. Can I set it up to treat the name of the paper ie. Tel as a value ie. 0.35? and then have it total etc?
View Replies!
View Related
AutoFilter Currency Values
I am trying to filter data using VB. I have a bunch of data that has currency. Some of the currency contains cents such as "32.50". I would like a user to be able to enter "32" and have everthing that is 32 dollars pop up even though there is a decimil point with cents in it. In the code below I tried using different variations of the "*" I tried putting it before, after, and both and it still dosen't work. I also tried using Range("Search!D17") as a Value and a Text. My code works filtering when I put the exact amount in for the currency but for some reason I can't get it to work when I only put in a partial amount If Range("Search!D17").Value = "" Then Goto 14 Else: Goto 13 13 Selection.AutoFilter Field:=13, Criteria1:= "*" & Range("Search!D17").Value "*", Operator:=xlAnd 14
View Replies!
View Related
Identifying Currency Format
When using the formula '= CELL("format",G3)' the result is ',2' for Euros, US and Canadian Dollars. As you can see in my spreadsheet this does not enable me to calculate sums (ie. Total Canadian Dollars) using the currency format. Is there something other than "format" that would get a more precise result that would differentiate between currencies?
View Replies!
View Related
Currency Conversion By Dropdown
I have a sheet of prices in USD, and want to be able to convert those numbers to Euro. I realize there is no formula to do this... I was going to list USD prices in cell A (which I was going to hide), and then in B have a formula to multiple the contents of cell A with the exchange rate. Is there a way I can create a dropdown cell and based on the contents of the dropdown change the currency items in cell B?
View Replies!
View Related
Inserting Minus Sign In Front Of Numbers In A Range
i want to know how to prefix a minus sign (-) before numbers in cells in a large range.i m working on a large sheet containing the Numbers with Cr and Dr as suffixes just like 445Dr ... 3331Cr and so..on... in the worksheet i want to know the method of deleting the suffixes and prefixing - sign infront of numbers having Cr as the suffix. Numbers with Dr as suffix denote positive numbers and numbers with Cr suffix denote negative numbers. i want to prefix the -minus sign in front of numbers having Cr in the end.
View Replies!
View Related
|
TRACKER
