convert fractions to decimals and decimal to fraction
Does anyone know if you can convert the following fraction to a decimal automatically.
7/8 x 2 1/4?
Thanks in advance, I will score big brownie points with the boss if we can
I keep my racing odds in fractions. I like to change them to decimals.
In one cell called A3 I keep the data, and would like the decimal value in A4.
If the first digit is L then the decimal value should always be -1.00.
eg L100\30 should be -1.00 in A3.
However, if the first digit is W, than I like the decimal value to be in cell A3
to two decimal places.
W10\3 should be 3.33 in A3
W3\1 should be 3.00.in A3
W10\11 should be 0.91
W11\4 should be 2.75
and trying to convert a spreadsheet I got which came with
fractions, I would like to convert them to decimals.
I am working on a spreadsheet to work out quantities of scaffolding. In the cell C15 I am left with a whole number and a fraction of 1/4, 1/2 or 3/4. I can change the fraction to a decimal if needed. I want to test to see if a fraction is present and depending on what fraction it is then one of three boxes has a 1 placed in it.
I may not have explained this very well, this is my first post here.
If any other info is needed please let me know
Finally got back to this today and it worked! Yipe
I'd like to be able to convert decimal to fraction of an inch. IOW I have calculated, from the circumference, the diameter (d=c/3.14) and would like to show the actual inches instead of the decimal
equivalent. 6.250 decimal would display 6 1/4, 6.375 decimal would
Related Applications & Scripts
This PHP script calculates and converts the decimal value of any latitude and longitude coordinates into easy-to-read degrees, minutes, and seconds.
CFM2ASP is a powerful program to help convert from ColdFusion to Microsoft Active Server Pages (ASP) written in VBScript.
The code editor in CFM2ASP is stocked with tons of your favorite features such as line numbers and auto indent.
Those who have tried to convert a web site or even just a few pages from ColdFusion to ASP know how long this can take. Most people would tell you the best method would be to start over with ASP. Now you can convert a page from CFM to ASP in about a minute.
Convert PowerPoint presentation to DPG video with Moyea PPT to DPG Converter for viewing PowerPoint on Nintendo DS.
Moyea PPT to DPG Converter stands out of the groups of PowerPoint to video converters for it can not only keep the original background music, voice narration, animations and transitions, etc. intact, but also enables users to convert several PowerPoint files to videos at one time, with no number limit.
- "I can't convert SWF to WMV on my Mac, as it is not a container file. What's this and how?"
- "What's the best software to convert SWF to WMV on Mac? I've got some SWF movies, but I want them in WMV format. I tried some online SWF to WMV converters, but the conversion always been interrupted by unknown error."
- "How can I convert my flash SWF file to WMV on Mac for my Zune? Which tool can I use?"
These are all questions raised by some common users in the forum. Have you ever encountered the same problem? Want to convert SWF to WMV on Mac, but haven't got a way or a right tool. After searching on the Internet, you may find that there are so many Mac SWF to WMV converters available, which one should you choose?
HTML Code Convert helps speed up the conversion of HTML code into different format including Java Script, JavaServer Pages, Microsoft ASP, PHP, Perl, Python, and the UNIX Shell. It is particularly useful in CGI scripting. HTML Code Convert is build with Gnome Library.