|
|
excel - doubling all figures
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Is there a way to double all the figures in my spreadsheet? I wrote a budget in US dollars and now I need to see it in Brazilian reals. Brazilian currency is about half of our currency value. <br><br>Can I do this? Big thanks!
|
|
0
|
|
|
|
Reply
|
 annie_Eastman
|
11/9/2009 2:20:08 AM |
|
One way I can think of is to use the "paste special" feature. One a separate sheet, fill the cells with "2", then copy the data you want to double, and "paste special" to the 2nd sheet with "2". Choose "multiple" in the dialog. <br><br>Thanks, <br>
XinXin <br>
Macintosh Business Unit, Microsoft <br><br>This posting is provided "AS IS" with no warranties, and confers no rights. <br><br>> Is there a way to double all the figures in my spreadsheet? I wrote a budget in US dollars and now I need to see it in Brazilian reals. Brazilian currency is about half of our currency value. <br>
> <br>
> Can I do this? Big thanks!
|
|
|
0
|
|
|
|
Reply
|
XinXin
|
11/9/2009 10:05:23 AM
|
|
I maybe know another way, if you are interested: <br><br>To make this whole think dynamic I would do the following: If you budget is in sheet A and you want to copy and multiply everything to sheet B. Make one cell in sheet A and enter the exact currency value of the Brazilian REAL 1.69707. let's say it is in cell N33 on Sheet 1. <br><br>Now go to Sheet 2 and enter "=(Sheet1!A1)*$N$33" in A1. Then drag and auto fill the rest of the whole page. <br><br>If ou now change anything in your budget OR the currency value in Sheet 1, It changes in sheet 2. <br><br>Hopefully I'm right. <br><br>Good luck.
|
|
|
0
|
|
|
|
Reply
|
qryn
|
11/9/2009 9:06:49 PM
|
|
thanks I will try both of these and let you know :)
|
|
|
0
|
|
|
|
Reply
|
annie_Eastman
|
11/10/2009 4:52:51 AM
|
|
|
3 Replies
161 Views
(page loaded in 0.041 seconds)
Similiar Articles: double spacing table in excel - microsoft.public.mac.office.excel ...... you double space the cells, lines, or whole tables within excel ... Hi all, All of a sudden my text box will only double space the lines, no matte what I do I cannot figure ... Finding Average of last 5 entries - microsoft.public.excel ...I'm trying to figure out a way to make an excel spreadsheet that will help me out with my ... which I had in mind: Function Avg4Last5(r As Range) As Double Dim i ... Y Axis labels: How to make them different to figures used to plot ...Y Axis labels: How to make them different to figures used to plot ... ... X Y (Scatter) Chart EXCEL ... ... You can modify axis labels in plot edit mode by double ... Converting a number (17 characters) to text (Scientific Notation ...I’m receiving an XML file that has excel formatting… ... Also, when I double click on a cell, I can edit it and ... I could not figure out a way to import as text... How to create Double stacked columns? - microsoft.public.mac ...The only part I cannot figure out is how to get the labeling correct... ... Processor: Intel Hi there, Does anyone know how to create double stacked columns in Excel Conditional formatting and percentages - microsoft.public.excel ...Conditional formatting and percentages - microsoft.public.excel ... Hi I have some figures in a ... I have a table with a field that is set to Number, Double, format ... Hide/Show sections (or tables) without VBA? Word 2007 - microsoft ...... in a protected Word document) Last challenge would be to figure out ... (2) Embed a section of an Excel worksheet in the ... user has to double-click the embedded Excel ... Sum Calculation Incorrect - microsoft.public.access.queries ...The figures are off by around 1.3 million (similar amounts over ... How do you know that Excel is correct >and not Access. > >Many double precision numbers wil contain round ... Print one page per sheet - microsoft.public.excel.miscOf course, we all know "the standard way my report prints ... Print one page per sheet - microsoft.public.excel.misc Hello, Can you help me to figure out what to change ... Access VBA - declared an Excel VBA reserved word and VBA/Access ...... on an Access 2003 application that interacts with Excel ... It didn't take long for me to figure out what I had done ... Declare a new variable: Dim ColumnWidth As Double ... Excel Figures - University of Wisconsin La CrosseDouble click on one of the symbols in the plot area. Line color: black Foreground ... This will paste the Excel figure onto the blank slide. 7. Resize the figure Rounding And Precision In ExcelUnder normal circumstances, Excel stores numeric values as "Double Precision Floating Point" numbers, or "Doubles" for short. These are 8-byte variables that can store ... Numeric precision in Microsoft Excel - Wikipedia, the free ...In the figure, Excel is used to find the smallest root of the quadratic equation x 2 + ... The Double data type is 8 bytes, the Integer data type is 2 bytes, and the general ... PsychInfo | Figures & Tables - Allegheny College: WebpubThe first step in creating any type of figure in Excel is to make use of the Chart Wizard. Highlight all of ... second may to get Chart Toolbar Options, just double ... How to use nested IF statements in Excel with AND, OR, NOT ...Tryingto figure: The commission is 6% on all sales that are at least 20% ... in charge of creating invoices on Excel for all of ... You should use the double quotes (above the ... 7/29/2012 3:21:23 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
14 followers. 