I am joining two columns of data. first col. has size in fraction format: 7 3/8
second column has text string:
HABITAT CINCY POD HAT ERA BLK/RD
Concatenate= HABITAT CINCY POD HAT ERA BLK/RD 7.375
Changing fraction to decimal, needs to remain fraction.
I have played w/ the formatting to make Number w/ zero decimal places and then selected Fraction, but no luck there.
I have a vba macro that takes data from one workbook and pastes it into another workbook. In doing this I have declared a few variables of type single (I only need two decimal precision). However, when I copy the values from the cells on the source workbook and paste them into the target workbook, the numbers end up having 12 decimal places. Ultimately, this extra precision causes my totals to be off by .01 or more after a while. I have tried rounding the number as I pull it off the source workbook into the variable, but that didn't matter. How do I solve this problem? Code for pulling data from source workbook:...
View 2 Replies View RelatedCould someone please tell me what is wrong with this formula. I have been looking at it for so long, I can't even concentrate .....
View 9 Replies View RelatedI am working on a simple calculater, what I want to do is figure sq. inches my problem is every thing I try the decimals won't calculate right,, this is a example of what I want to do
8.25x10.75= 81 sq"
I know that if I enter =3/4 in a cell it will give me .75 but is there is formula to convert fractions into decimals or is this the best way to do it? I was also wondering if there is some way to convert the decimal amount to a fraction
for measurement conversions I know that
=B3*25.4 will convert a decimal to mm and so will the formula =CONVERT(E4,"in","mm")
and to convert mm to a decimal a few formula that work are
=CONVERT(H3,"mm","in")
=MROUND(H4/25.4, 1/8)
=H5/25.4
=INT(H6/25.39999918*8)/8
But is there a way to convert a fraction to the decimal and is there a way to convert mm to a fraction instead of the decimal equivalent of the fraction?
or maybe a formula to convert mm to inches but instead of the result being in decimal format it would be in fraction format?
i have a combo boxes populated with fractions 1/16, 1/8, 3/16, 1/4 etc up to 15/16.
i just want to output the chosen fraction to a textbox as a decimal.
This is done in a userform, not in a cell.
Basically, I want to format a group of cells to display 1 decimal figure if the number is not a whole number. If the number is a whole number (or if the rounded first decimal place is 0) I want it to display no decimal.
View 9 Replies View RelatedI need to convert a column of numbers currently formatted with 2 decimal places e.g. 112.12 to 4 decimal places (without the decimal point). I need the end result to be 1121200. I've tried a few different suggestions given on the forum previously but can't seem to retain the 4 decimal places that I require.
View 4 Replies View RelatedI have to make a excel document in which I have length and width in feet and inch format.
E.g. 10.01 in which 10 is feet and .01 is inch
I have all the length and width values in the above format. And what I want to do is convert the inch value (10.01) to feet value (.01=.08 feet) .
Just like the calculator here does.. [URL] ........
Like
10.01=10.08
10.02=10.16
10..03=10.25
...and so on...
Here is table of conversions from inches to decimal feet. But I don't know how to get a formula for this in excel...????
Inch Decimal of a Foot
1 inch 0.0833
2 inches 0.167
3 inches 0.250
4 inches 0.333
5 inches 0.417
6 inches 0.500
7 inches 0.583
8 inches 0.667
9 inches 0.750
10 inches 0.833
11 inches 0.917
12 inches 1.000
I am trying to create a unique sample code by putting together the values of other cells that a user will input. It's all working well apart from the last part, where I am trying to include a decimal number. I want the decimal number to appear without the central "." and in a four digit format. e.g. 2.5 would appear as 0250, 14.25 would appear as 1425. This is the formlua I am using currently:
=IF(ISBLANK(B4),"",IF(LEFT(C4,1)="w",(B4&"-"&TEXT(F4,"YYMMDD")&C4&TEXT(G4,"HHMM")),(B4&"-"&TEXT(F4,"YYMMDD")&C4&LEFT(TEXT(H4,"00"),2)&RIGHT(TEXT(H4,"00"),2))))
However, where the value of H4 is 2.5, I am getting a result of 0303 (I've put this part in bold). I have attached a small spreadsheet to aid understanding.
I need a formula to multiply only the decimal number in a cell and not the integer. For example: the number in the cell is 57.3615. I want to multiply .3615 only.
View 2 Replies View RelatedHow do I get a fraction to show as a fraction rather than decimal in the formula bar by formatting the cell as text.
For ex:
I have "-3/4" in a cell formated as "TEXT" I expect it to show "-3/4" in formula bar but it shows "-0.75".
Im combing 2 cells into 1 but using a fraction..
I created 2 examples of what im trying to do..
Example.
A1 = 22
A2 = 11 3/4
=A1&"'-"&TEXT(A2,"# ?/?")&"''"
[b]22'-11 3/4"[b]
but when A2 = 11
i get this..
22'-11___''
on excel it has some space between the 11 and '' but i cant show that here..
i would like the '' to be next to the 11. is there any way to do that?
I have copied from a website some data regarding steel weights, for example 1/16 .005 copies to one cell, when I try text to columns to separate the whole column and move the decimal .005 to the next column the 1/16 changes to 41290. The data copies quite well as HTML into Excel except for where a lone fraction value becomes a 5 digit number beginning with 41***. I can find no conversion calculator on the web to determine what's happening.
View 4 Replies View RelatedCan anyone help me with a code for converting decimal number to a nearest 1/16 th fraction. For example converting number 2.1875 to 2 3/16 and so on...Also if it is 2.5 it should display 2 1/2...
View 14 Replies View RelatedI write up job cards that require measurements in fraction form. Usually whenever i want to round off a figure , say 10/16, to 5/8, i right click on the figure and format cell it. However, this can be quite time consuming if there are multiple cells and are of a different breakdown.
What i would like to know if there's a shortcut way where when the 10/16 is in the cell, it automatically rounds off to the nearest fraction.
I am wanting to get a function that can get the number from a fractions left side only . 13/14 2/1 1/5 etc
Col A varies in lenght so using a right function doesnt always work .
The result i need is in col B .
Sheet1 AB1DataResult2Fred Swchensoncenson [R63] 57 (13) 13/14 $39.40133Bob Bill [R54] 65 (7) 2/1 $3.3024Patrick Patrick [R56] 65->63.5 (10) 1/5 $12.6015Le Le [R56] 65 (2) 6/6 $3.4066John Ringopeterpaulandmaryslambgoingupahill [R58] 65 (2) 1/1 $2.8017Gold Silverbronzmetalmedals [R61] 58.5 (5) 16/15 $33.90168Mr Mycardontrun [R59] 68 (4) 1/1 $6.701
Is there any way of formatting a cell to show a percentage with a fraction? For example, I'd like to show: 3 1/3%, 1 2/3%, 2 1/2%, etc.
I'm showing data to a client who will pull out his calculator and add up the decimals on his calculator and be unhappy that the numbers don't add up to 100%.
I can force the output by using TEXT() or multiple columns, but ideally, I'd like a custom format if possible.
I am trying to round a number down to the nearest 1/4". For example;
Round Down 8.80" to 8.75".
Is there any combination of Rounddown and Mround that will accomplish this?
I am trying to paste in a decimal equivalent chart, loacted here:
http://www.advancedtool.com/prod02111.asp
which basically has a mixture of whole numbers and fractions, and how they equate in decimals.
When I paste this in, all the fractions turn into dates. So for instance 1/64 turns into Jan/64, and 1/32 is Jan/32. Now, I could go in and change each one, but I would like to know how to do this with cell format on the entire sheet....
I have tried to change the cell formats to "general" or "text" and of course fraction, but in this case, I have to go in and do each fraction cell individually. Now maybe I am being too lazy, and in the time it took me to look up my login information, and type this out, I likely could have re-done the worksheet, each cell individually, but I would like to know the way to fix this automatically.
I have created a "heat map" in VBA that takes fractional values and "ranks" them in 10 equal bands, then assigns a colour to each band. (Hopefully that made sense to you VBA experts out there)
However, I now want to look at the numerators of these fractions, rank these, and do something like "if the numerator is > x then proceed, else exit. Is there a way to reference these numerators directly? If so, is there a way to store them in some sort of array then take the max value too?
I've tried searching this and it seems like this should be a simple answer, but is there any way I can reference the numerator of a fraction in Excel? These cells will contain formulae; so they'll be E5/C5 for example.
I simply cannot insert a one eighth symbol in my spreadsheet.. I used to be able to see this in the Insert Symbols grib but now all I get are lots of question market.. if I use
selection.value = ChrW(8569)
the symbol does appear until I select the cell and press return, after which point it turns into a question mark.. I'm sure its something to do with my settings but I can't figure out what.. this is really important for me.
I have attached my excel sheet. I have continuous fraction numbers in every attribute value. How can i write vba code for replacing continuous fraction numbers in on row
Attribute name1 Attribute Value1
materials1 1/2 IN ID, 2/3 IN LG, 4/5 IN OD 1/4 IN THK
materials2 1/2 IN ID, 2/3 IN LG, 4/5 IN OD
materials3 1/2 IN ID, 2/3 IN LG
example: 1/2 IN ID, 2/3 IN LG, 4/5 IN OD 1/4 IN THK in a single row
I have TOOL OUT sheet
ModelNumberAttributeValue Replace Value
1materials2/4 IN LG, 3/4 IN ID, 5/9 IN OD,1/15 IN THK
2materials1/2 IN LG, 2/9 IN
3materials4/15 IN
4materials5/18 IN
5materials4/19 IN
6materials2/4 IN
7materials1/2 IN
8materials4/15 IN
9materials5/18 IN
10materials4/19 IN LG, 9/8 IN
11materials2/4 IN LG, 3/4 IN ID, 5/9 IN OD,1/15 IN THK
I want this to converted in (Replace value column)
Example 0.5 IN LG, 0.75 IN ID, 0.55 IN OD,0.06 IB
Tool_to_replace_Fraction_to_decimal_v1_MrShorty.xlsm
Inmates can apply for pre-release when they have half their minimum sentence served. For example 2 years 6 months. They would have to serve 1 year 3 months.
I use this formula
=DATE(YEAR(A1)-A5,MONTH(A1)-B5,DAY(A1)-B6)
Where A1 is half the years, B5 is half the months, and B6 is half the days. The problem is when an inmate is sentenced to a minimum of 3 years and 3 months. The latter formula will not calculate 1.5 years or 1.5 months. It rounds up. What I would like to do is covert the 1.5 years to months and the 1.5 months to days.
Below is a sample. I was given a spreadsheet and it contains fractions formatted as General. I need to do a calculation based on the fractions. Example there is a number in A1 lets say 3 and a fraction formatted as general in a2 1/216 and I need to multiply A1 * A2 but obviously I get a value error. If I go to another sheet and format the cell as a fraction then the multiplication works. My spreadsheet is full of the general formatted fractions.
A1321/2163 4 5 60.0138888897 8#VALUE!Spreadsheet FormulasCellFormulaA6=(A1*1/216)A8=A1*A2
I have row 2 formatted as a fraction and row 1 formatted as percentage.
I am looking for way to return the percentage of row 2 in row 1. I.E. If i have 3/4 in a2, I want it to return 75% in a1. I have figured a formula to return a percentage for numbers with only 1 item to the left of the division sign (i.e., 3/4). That correctly returns 75%. I am struggling with working a formula to also return larger numbers (e.g. 12/15).
I'm using excel 2010......
Is there any way to display one-third 1/3 in a Userform label control?
View 9 Replies View RelatedI have a cell with the following text in it that is being imported from a website "5/1 Smith T win". What i want to do is extract the "5/1" part without it being in the format of a date. I want it to be extracted in the format "?/???". I have entered the following formula to extract the "5/1"
View 2 Replies View RelatedI have a file that has been produced using Statistica software. The file is supposed to have around one million rows, and when exported to Excel the file is about 30 MB. When I open the .xlsx file in Excel 2010 only two pages of data appear. The rows also have weird numbering. The first square of the A column is A1. The second is A3833, the third is A6789, then A8161, then A8162, then A8163, then A8164, then A18070.
The scroll button to the left of the screen is long, as if the document was only two pages long. When the scroll button is click-and-dragged a small beige square appears with a row number. This small square seems to be aware that not all rows are shown as it shows many more rows than are visible to me.
I want the user to press a button on the spreadsheet and this should then result in a popup box appearing on the screen asking the user one question ie "what is the current rate"
The user will then enter for example 20%. I then want to transfer this number to cell A1 on sheet 1.