Excel 2013 :: All Sheets Being Automatically Changed To Currency Format

Dec 2, 2013

We have 3 PCs, all running MS Office 2013. On 1 of these machines, it is doing strange things with formatting. If you open a document or try to paste anything into certain documents, it decides everything is currency format and assigns all sorts of wrong formatting to the entire sheet, or the entire document. There may be some cells in the doc that are indeed currency, but only a small proprtion. If I open a new, fresh document and paste into that document, it does not do this, it seems to work normally, only applying currency formatting where it might be applicable. On some larger docs that have this issue, no matter what I do, it just continues to apply these strange settings.

View 2 Replies


ADVERTISEMENT

Excel 2007 :: Automatically Converting All CURRENCY Symbols To ONLY Currency Selected

Mar 11, 2012

How to make EXCEL 2007 Automatically convert all my CURRENCY symbols in all cells formatted for CURRENCY in THE SAME SHEET to the one and ONLY currency selected in JUST ONE cell ? (i mean, after conversion, all of them are Not just display currency symbols, but Calculable monetary values like regular Excel's built-in currency format)

I am a dummy in VBA so I really am not familiar at all if the solution is really one of VBA. I don't even know how to start programming VBA at all in Excel.

View 3 Replies View Related

Excel 2003 :: Changed Currency Display

Mar 13, 2013

This is the user form:

Dibujo.JPG

All the labels and cells in the original file are in dollars.

When I send it to some computers it changes to euros, like so:

Dibujo 2.JPG

I created the file in Excel 2003, and it changes to euros in both Excel 2003 and 2007.

Step by step process to format back to dollars?

View 1 Replies View Related

EXCEL 2013 :: Show Currency Exchange Rate In One Cell

Apr 16, 2014

Is it possible in Excel 2013 to have one cell show current exchange rate of Euro to dollar?

View 1 Replies View Related

Automatically Change Currency Format

Jul 13, 2006

AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy/pasting, but IS if the keyword uses "quotes".

USD 100
EURO 100

Is it possible to automatically make it:


USD $100
EURO 100

View 9 Replies View Related

Excel 2013 :: Automatically Reapply Filter

May 22, 2014

I have a Table ("Table2") in a worksheet ("Dashboard") that contains monthly data arranged in rows. I have made the data fields show #NA for months I want to exclude based on dynamic criteria.

Now, I would like to automatically filter out the rows (months) with #NA so that they are not charted.

It works manually but I have to Right Click on the Table --> Filter --> Reapply every time the source data changes. How can I make this happen automatically so that the user does not have to manually reapply each time.

View 6 Replies View Related

Excel 2013 :: Automatically Calculate Area Between Two Charts?

Dec 22, 2013

I have Excel 2013.

Find attached a sample fileDummy for area between.

charts.xlsx

View 3 Replies View Related

Excel 2013 :: Disable Automatically Scrolling To The Top Of Current Cell?

Jan 2, 2014

I am using Excel 2013. I have a spreadsheet that has a lot of very tall cells. When I use the scrollbar to scroll to certain parts of the spreadsheet it will automatically scroll up or down to the top of a cell. So if I want to view the middle of two tall cells that take up the whole screen it will automatically scroll up to the top of the highest cell that I'm currently viewing.

I just want to be able to scroll to where I want to scroll without Excel moving me up or down. I've tried to find answers on message boards but no luck.

View 2 Replies View Related

Excel 2013 :: Print Workbook In Particular Format

Mar 1, 2014

I'm trying to print an excel workbook in a particular format. I have several sheets. I would like the information on each sheet to be duplicated directly to the right of the info, on the same printed sheet in Landscape layout. After printing, I need to be able to stack the workbook and cut straight down the middle. This way, I have two identical workbooks with identical margins, perfectly centered.

Is there an easy way to do this without copying and pasting the cell data into the spreadsheet as well?

If there is not, and I must have duplicate tables on the same worksheet, is there an easy way to format the printing so that they print out perfectly aligned?

I've tried to use the ruler function in the print page to stretch, but, it only stretches a particular row/column.

View 1 Replies View Related

Excel 2013 :: Using Macro To Format Table?

May 14, 2014

I am using excel 2013. I have the table look like the above, in the diagram 1, i want to have the macro such that it can be formatted to the 2nd diagram. Can this be done using macro ? [URL]

View 2 Replies View Related

Excel 2013 :: Conditional Format Named Range

Mar 15, 2013

I have a spreadsheet that keeps track of the equipment we have on rent. Whenever we have a new rental, I insert a row and enter the information. I have several conditional formats I am applying - (1) making the font a light grey so that it is hard to see on any rental that has been called off, but invoicing isn't complete on, (2) making the font red on any item that is within 3 days of the term, and highlighting any row that isn't showing an invoice in over 45 days. When anything is completed (rental has been called off, and the final invoice has been approved), I cut the row out and put it in a sheet entitled "Closed Equipment". When I cut out closed records or add new records, it will occasionally mess up my conditional formatting by only referencing one row. Additionally, I don't want the conditional formatting to transfer over to the "Closed Equipment" tab.

Would this be easier to keep clean and straight if I used VBA? Or should I just continue to occasionally check my conditional formatting and clean it up? I thought if I used a Named Range instead of cell references, it might work better, but entering named range "On_Rent" converts to the cell range ($A$4:$AA$194).

I am using Windows 8, Excel 2013. The file is on a network drive, and others in the office can look at it (they all run Windows 7, and either Excel 2010 or 2007), but they look at it so seldom.

View 1 Replies View Related

Excel 2013 :: How To Make Automatically Fill In Dates For Weekdays Only And Skip Thursday

Feb 9, 2014

I have class monday, tuesday, wednesday & friday but no class thursday. How can I make automatically fill in dates for weekdays only and skip thursday using excel 2013's "Fill" function then "series" ??

View 6 Replies View Related

Excel 2013 :: Speed Protect / Unprotect Sheets

Apr 29, 2014

I experience it takes a lot of time to protect/unprotect sheets in Excel 2013. However, only if the operation is made WITH PASSWORD. This was not the case in Excel 2007. Operation was fast independent with/witout password.

In attached file I have made an example where the time to protect/unprotect 25 sheets is investigated. Can make the test in Excel2013 to double check it is not my computer causing the time delay.

Result test - 25 sheets:
Protect - No password: 0,02 s
Unprotect - No password: 0,06 s
Protect - With password: 6,9 s
Unprotect - With password: 6,9 s

View 7 Replies View Related

Excel 2013 :: How To Hide And Unhide Headings From All Sheets At Once

May 14, 2014

i want to hide and unhide headings from all sheets at once (Excel 2013)

View 8 Replies View Related

Excel 2013 :: Mirror Range Of Cells In Different Sheets?

Jul 9, 2014

I would like to mirror a range of cells between two sheets in the same workbook, so that if the data is manually input into one of the cells in range (E5:H11) in 'Sheet 1', it is automatically updated in the corresponding cell in (H33:K39) of 'Sheet 2', and vice versa.

Using Office 2013. T

View 6 Replies View Related

Excel 2013 :: Auto Naming Pivot Sheets

Feb 28, 2014

Is there a macro available which will create a pre-defined name for a pivot sheet, which will contain the word "Pivot" followed by a underscore "_" and the name of the sheet on which the pivot is applied.

Example: I have data on a sheet called "Salary" and put a pivot on "Salary" on a new sheet, the new sheet should be auto named as "Pivot_Salary"

Am using Excel 2013

View 1 Replies View Related

Excel 2013 :: Format Date / Time And Macro To Run On Opening Orkbook

Feb 2, 2013

I need to place a date and time in a cell 14/9/2013 6:00 PM

Tried several formats under custom format without success.

Also need addition to following macro to enable it to start on opening of workbook

Code:

Sub Macro1()
Do
PauseTime = 1 ' Set duration.
Start = Timer ' Set start time.
Do While Timer < Start + PauseTime
DoEvents ' Yield to other processes.

[Code]...

View 8 Replies View Related

Excel 2013 :: Generating Master Sheet From Other Sheets Within Same Workbook

Mar 25, 2014

I have a workbook with five sheets. One sheet is the Master and then one sheet each for four organizations. Each organization will populate data for their own sheet and I want Excel to automatically populate the Master with the info from each individual sheet.

I tried using and modifying the vba from this post [URL]). My workbook varies from the original in that the first seven rows are header rows so the first cell to be edited in each sheet is A8, I have 38 columns instead of 10, and I am using Excel 2013 instead of Excel 2003.

I figured out that I needed to change the vba to look like this to start copying from the first cell (A8) and to populate the master:

This seems to work, but until the first cell (A8) is populated in the organizations' sheets, it messes up the prior row on the Master (Row 7).

I've also noticed that undo becomes unavailable when switching between sheets and also copy/cut & paste between sheets doesn't work so I can't correct the way the script messes up the format initially (this I presume is due to the Copy Destination in the vba?).

View 1 Replies View Related

Change Cell Format Based On Existing Currency Format

Jun 12, 2008

I would like to have a single button that changes a range of cells from the USD to EURO to perhaps CAD symbol. Can this operation be performed, such that if I start in dollars, and I click the button once, it shifts by range to EURO (not formulas...just symbol)...and then if I click the same button again, it goes to CAD, and then back to USD with a third click?

View 5 Replies View Related

Format Currency As Correct German Format

Jan 23, 2009

I have a spreadsheet which needs to display currency in the correct format dependant upon whether a contract is in English or German Law. Excel defaults currency format as 310,000.00 however in German this needs to be 310.000,00 i.e. with the decimal point and comma in opposite positions. Does anyone know what expression I can use to format it as the latter?

View 2 Replies View Related

Excel 2013 :: Pivot Table Compare Current Data With Refresh Data And Format New Values?

Jun 18, 2014

vba in excel 2013 pivot table that updates from an online CRM rows are a to h and it can be any number of rows. What I am trying to do is track progress. In column f values indicate probability for success 10 25 45 90, which can go up or down. The pivot table is refreshed to get the latest values from CRM. the update is handled by a connection to the crm not in the vba.

So far I been researching methods to conditionally format values that went up, down or remained the same since the last refresh with up down and across arrows. I have managed to piece together what I think should work but alas it is not. So I have come to you internet.

My code first clears any formatting and goes down the column avoiding null or empty cells, comparing the values in column f to values in column j.
I have 3 conditions greater than, less than or equal to, and would like add an icon for each based on the result of the comparison.

Finally when it finishes the column the code copies the current values in the pivot table column f to column j outside the pivot table which i hope to be able to hide once the cf works. The code is below

[Code] .....

View 1 Replies View Related

Format Textbox As Currency?

Mar 16, 2012

I have a textbox on a form that has a default value of 0.00. When the user enters a number I want it to format it to currency with two decimal places. I've tried form.textbox1.text = formatcurrency(textbox1.text,"0.00") but it won't format it to two decimal places.

View 2 Replies View Related

Format Currency In IF Statement

Mar 25, 2008

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 9 Replies View Related

Identifying Currency Format

Jun 20, 2006

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 7 Replies View Related

Format Textbox For Currency

Sep 21, 2007

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 9 Replies View Related

Automatically Run Udf When Color Is Changed

May 2, 2007

I have a UDF that goes like this:

Function SumIfPurple(inputRange As Range, _
answerRange1 As Range, _
answerRange2 As Range) As Variant
Dim SumAnswer As Variant

'If inputRange is turned purple then it is equal to anserRange1, if it is left with no fill it is equal to answerrange2.

If inputRange.Interior.ColorIndex = 39 Then
SumAnswer = answerRange1.Value
Else
SumAnswer = answerRange2.Value
End If
SumIfPurple = SumAnswer
End Function

I would like to have a sub that will have the formula automatically calculate when the inputRange's color is changed.

View 6 Replies View Related

Negative Numbers - Currency Format

Mar 1, 2013

The negative numbers in my currency format does not have any numbers with parenthesis or minus, is there any way that the default format can be changed other than always trying to use a custom format.

View 5 Replies View Related

Currency Format In Textboxes Of Userform?

Feb 11, 2014

I have a userform that one textbox takes it's value from a cell in sheet3.(k2). The format of this cell is currency. How the textbox takes the same format as the cell?

In the same userform i have a series(prcase1,prcase2..) of textboxes that i want to have currency format as the user type numbers on these.

How can i do this?

View 11 Replies View Related

Format Currency In Thousands,lakhs

Apr 27, 2009

i want to know how to numberformat numbers (Currency) into thousands,lakhs.
For example i m having amount in colmun D like 1239.00 i want to format the numbers in this column as Currency with thousand seperator and lakh seperator. like1,239.00 or 1,23,900.0

View 2 Replies View Related

Multiple Currency Format From UserForm?

Feb 26, 2013

I have a UserForm with a ComboBox for the currency (30-35 items) and a TextBox for the amount.

The currency codes are displayed like this: EUR, USD, RUB, GBP etc.

How do I paste the result of TextBox in a selected currency format in a cell in worksheet?

Example:
ComboBox value is "USD"
TextBoxValue is "500"

Cell A1 value should read "500 USD" as currency not text.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved