I have a macro code which save the open Excelfile as .pdf in the same folder as the Excel file. This is fine. This is also the folder 1 in which the macro should save the .pdf.
But how is it possible to save the file also at the folder "C:output" with the name of the "excelfile.pdf".
I would like to add some icons on the left side of excel open file pane to faciliate my work. Because i need to load some files under the same folder many times a day. Does anybody know how to do that? I've seen people has more icons on the pane before. The defaut setting has only 'History', 'My Documents', 'Favorites', 'Desktop' and ' My nutwork places' on it.
View 2 Replies View RelatedI need a formula to take a number with several decimal places and round it up to two decimal places to either .33, .66 or, .00 if its above .66.
For example, 4.23423423423423 will be 4.33
4.43453453533434 will be 4.66
4.8353453453 will be 5.00
Lets say the number is in cell A1. What formula would do this?
I was going to use the following to test that a number has no more than two decimal places,
Code:
If Int(ActiveCell.Offset(0, 8) * 100) ActiveCell.Offset(0, 8) * 100 Then
However it is rather mysteringly failing when activecell = 16.99 or 17.99; on testing it appears that vba is evaluating Int(ActiveCell.Offset(0, 8) * 100) to equal 1698 or 1798
I am converting values from SAE to Metric and wish to retain the decimal places of the SAE value before converting.
My code below converts nicely but doesnt maintain decimal places.
What do I need to add to this code to set the decimal places to zero?
View 2 Replies View RelatedI am facing a problem with Excel's Concatenate function. I am trying to make a text string with numbers from a cell. =CONCATENATE( "price paid= ", D23). D23 is a numreric cell, formatted for one decimal place. However, the text produced by above function is showing me two decimal places of the number in D23.
View 4 Replies View RelatedI am creating a Daily Cash Count worksheet for a business to do their daily closeout paperwork. What I am trying to do is automatically apply decimal formatting to a cell. Examples, if they count 60 cents in nickles and enter 60 in the cell, it automatically converts it to .60. And if they count 7.50 cents in quarters and enter 750 in cell it automatically would convert it to 7.50.
View 7 Replies View RelatedI'm trying to work out a formula in excel which requires me to use Pi to over 30 decimal places. Excel will only let me have 30 decimal places of Pi whether I copy and paste it as a number or use its Pi function and even then seems to round up. Is there any way I can get more than 30 decimal places for this calculation? If not in excel then can anyone suggest another programme that may be capable of this? You can post here or contact me at [email=" Deleted by Jack in the UK[/EMAIL]
View 2 Replies View RelatedIs it possible to apply some kind of formatting to a range, that will force all numbers entered into that range to have the same number of decimal places as the cell with the maximum number of decimal places?
View 9 Replies View RelatedEverytime I enter a number, excel automatically converts it to a decimal number.
I type 1 in a cell (or formula box)
Excel returns the value as 0.1
I think it may have to do with the FIX box highlighted to the bottom of the screen. (To the right side of the NUM lock). (I can't paste a screen dump to show the FIX box position). how to remove the FIX box, and/or change excel so that I can enter in numbers normally.
I'm looking for a solution to freeze panes twice. That is I want to freeze row 1-15 and row 200-203. And then the rows 16-199 to be movable. In the first 15 rows I have column info so I need that visable all the time and in row 200-203 I have " Sum" of the lines 16-199 so that's why I want that to also be visible at all time. The ordinary freeze pane in excel just freezes at one certain horizontol point and I need 2. Can it be done with VBA maybe? Is it possible to insert an up/down arrow (the one you have at the right side of the screen, don't now what it's called) for the lines 16-199?
View 3 Replies View RelatedI want to show (in a cell) how much decimals there are after a comma.
View 9 Replies View RelatedIs there a way to format a number into 2 decimal places and when you select the cell you wont see the true value?
For example:
316.2696
I still see the 316.2696 when I click the cell. Instead of 316.27 only.
I'm on Excel 2010 and I need to round up a complete price list to a 0.90 decimal.
Here is the formula that I have in my cell : =((J5-(J5*N$2))*M5) I need to round the result to XXX.90
I am doing some calculations via Excel, and I have found that I get different results using a calculator. I know that by formatting the number, I can show as many or as little decimal places as I like in any cell, but can anyone tell me how many decimal places Excel actually uses when it's carrying out calculations? I have a feeling that the Excel results I'm getting might be more accurate than my calculator ones.
View 2 Replies View RelatedI am using Excel 2003. I am attempting to use the Accounting format with numbers that should not have any decimal places (although what is entered might have a decimal place). The numbers line up fine on the right, however, the dollar signs on the left are not lining up. It looks something like:
View 4 Replies View RelatedI'm trying to speed up some work on an excel sheet. The sheet converts degrees latitude and longitude to Northing and Easting coordinates, but right now we have to type them in directly.
For example, the degrees would be 81.0056 and I want to reference just the .0056 from the cell that contains the whole 81.0056 degrees. Is there any way to just reference character place three through seven of that cell? All I'll need it to do is copy it over, the rest of the program will convert it for me.
I have a simple spreadsheet that allows the user to enter a dimension in metric or inches. I want to display the other units in the adjacent cell. In cell A1, the units are "Metric" or "Inch" in a pull down list. In cell A2, the value is entered.
In cell A3 i want to show the value in the other units. So if A1 is Metric, then take A2 and divide by 25.4. And if A1 is Inch, then take A2 and multiply by 25.4.
Also, if A1 is Inch, then display 2 decimal places in A3, and if A1 is Metric, then display 3 decimal places in A3. Is this possible?
How do I write a formula to round the decimal places in a number in set increments. For example;
a) 14.28 to the nearest 0.25 would result 14.25
b) 1.99 to the nearest 0.1 would result 2.0
c)2.97 to the nearest 0.25 would result 3.00
Using Excel 2010
Workbook with 21 sheets, first sheet is the summary sheet (named SUMMARY) taking all it's content from the other sheets, named from 1 to 20, which are all laid out the same, but contain different data.
My problem is that I want to get rid of decimal places that are being brought into the SUMMARY sheet
In sheets named 1 to 20, I am using the following formula in H23 to arrive at a figure =IFERROR(100/(B5/B23),0) in H23
B5 and B23 are always whole numbers on all sheets 1-20, result can be whole or contain decimal places which I round up in the cell to show no decimal places
On sheet 1, B5 is 200 and B23 is 5, giving 2.50 as the answer, which is right, I have H23 set as a number cell with no decimal places so it rounds up to 3 which is what appears in the H23 cell.
All of the above is correct and appearing as I want it on the sheet, the problem arises when I import into the SUMMARY sheet as follows:
On the SUMMARY sheet in cell B59 I want the following to appear 5 - 3 but am getting 5 - 2.5 using the following formula
='1'!B23&" - "&'1'!H23
The first part is fine as B23 will always be a whole number
How can I stop it from bringing in the 2.5 and get it to bring in the rounded up 3 into cell B59
I have cell B59 set as a number cell with no decimal places but it still appears as 2.5
Also when I correct it as it appears a lot on the summary sheet, how do I get the following to happen
='1'!$B$23&" - "&'1'!$H$23
if I fill the above across columns how to I get the two '1' s in the formula to become '2' then '3' as I fill across.
I am having an issue with number format in my VBA code. The entire column of column D is format as ###.0000 (4 decimals places). There are certains cells which require zero decimal places. I am using the following bit of code, but it is not working correctly. It is still formatting the cell as 4 decimal places.
View 3 Replies View Relatedif I change the formatting of a cell to 2 decimal places, it appears as two decimal places (as it should) for example $88.88888 will show as $88.88
However, when I use this data in another application that displays this data it will display as 88.88888 still. I need to actually take the value and truncate it to 88.88 eg 8.8888888 will become 8.88
I have been using trunc by hand and wanted to try and find out if there is a way that I could write some sort of macro to do this for me each time.
Below I have this formula in cell A6, in the cells the formula refers to B6 thru O6 contains formula's also. There is text and numbers in the cells. The cells with numbers are formatted as number to 4 decimal places.
The problem is in cell A6 the numbers go to 15 decimal places. I don't know why but I need to keep it to 4 decimal places.
=B6& "" &C6&G6&H6&I6&J6&K6&L6&M6&N6&O6
G01G41X0.0125Y0.0125D(offset#)F0.39
This how cell A6 is after the inputs are in below.
G01G41X0.01249976025Y0.01249976025D(offset#)F0.386021052631579
This is how I need it to be below.
G01G41X0.0125Y0.0125D(offset#)F0.3860
Can anyone figure this out.
Wheather it is a formula or vb code
How do I stop a user from entering more than 2 decimal places?
If I format the cell to "0.00" I can still type in 1234.1234 and it will display 1234.12.
If I select that cell, the value in the formula bar is still 1234.1234.
I have a problem with the currency format with 4 decimal places.
Sub go()
Range("C5") = Range("C5") + Range("C4")
End Sub
as you can see it adds the conecnt of "R4" to what is in "R5"
If works fine when the calls are formatted as number with 4 decimal places.
example if R4 is 0.1111 and R5 is 0.2222 after running the macro R5 becomes 0.3333
But if the cells are formatted as currency and 4 decimal places the then excel returns $0.3300
Is there a function in VBA that lets me increment or decrement the number of decimals of a particular cell? let's say i got a cell value of 7.123456 but excel only displays 7 on the cell. What if i want excel to display only 7.123? How can I specify the number of decimals i want on a particular cell (in this case 3)
View 2 Replies View RelatedI have a column of numbers with one decimal point and some blank entries too. I need to convert all the numbers (including the zeros, but not the blanks) to two decimal points. Any idea on how this can be done?
Examples: 0.1 needs to become 0.10, 0 needs to stay 0, a Blank cell needs to remain Blank.
AVERAGEIFS(X$2:X$1000,$AT$2:$AT$1000,1)& TEXT(BE2/BD2," 0%")
The formula is working , but the result is : 3.50239234449761 58% Formatting the cell did not work. Can these decimals be slashed?
I have to change a time sheet that was previously in HH:mm to display in decimals, but to the nearest 1/4 hour ( 0.25 (=15 mins), 0.50 (= 30 mins), 0.75 (=45 mins), and 1.00 (1 hour))
This is not a formula question, but a format/display question as the cells have to be typed in by different people who up until now have beeb used to typing in the HH:mm format.
This means;
8:15hrs would become 8.25
8:30hrs would become 8.5
8:45hrs would become 8.75
The reason behind the change is a head office wallah that needs to have time in decimals and not true minutes.
Is there a way to;
prevent user from entering any decimal other than .00; .25;.50;.75
or change formatting to turn red if any other than above is entered.
Alternatively, is there a way of me (the collator for 50 people) being able to take data from their sheets (which I have to do monthly) which could be a formula...
I have tried to get head office to change, but they say that they collate data for 13 other sites and all the others are OK (thats cos all the others receive their data on PAPER and one person tabluates them)...