# Convert Numbers With Decimals To Percentage

Nov 11, 2008

I have a spread sheet with over 200 numbers like 3.3, 4.5, 6.6 and so on. Is there and easy way to convert them to Percentages?

## Convert Degrees Minutes & Decimals Of A Minute (12° 34.567') To Degrees And Decimals Of A Degree (12.57611°)

Oct 29, 2008

I am trying to convert Degrees Minutes & Decimals of a minute (12° 34.567') to Degrees and decimals of a degree (12.57611°). I have the formula to convert latitude, that is two digits, but it doesn't want to work with longitudes, three digits. (see attachment). This is the formula that I am using:

=IF(A2="","",(INT((LEFT(A2,3)+MID(A2,4,6)/60)*100000)/100000)&"d")

## Countif With Decimals To Give A Percentage..HELP!!

Nov 19, 2008

This one sounds easy but I have spent a lot of time on it and no success. I have a list of students with various levels next to each name. EG: 4.5, 5.6, 5.7, 6.1 etc. From this range I want to work out the percentages of achiveing Level 5, 5 and above, Level 6, 6 and above. By doing a countif it counts 5 not 5.1 5.2 etc. How do I get over this? Attached is a sample.

## Decrease Decimals If Cells Formatting Is In Percentage

Feb 27, 2014

Is it possible through a macro that the cells where numbers is in percentage format should not show any decimal points (is should not roundoff) just decimal points should not visible. I am aware that this can be done by "decrease decimal" but data will be across thousand of rows manually it will be very time consuming.

I have attached a sample worksheet : Percent.xlsx

## How Can I Convert Decimals To Fractions?

Nov 19, 2008

1.25 is in cell A1. This number will often be buried in a longer part number that may look like ELL-1.25-S40.

I would like to use a formula in cell A2 to display the fractional equivalent (1-1/4).

## Convert Decimals To Feet & Inches

Nov 16, 2006

I need help shrinking down my formula to make it fit in one cell.

Right now, the way i have it, it spans across (7) different cells to get the results i desire. Is there a way i can make this shorter?

A11 – This is where the decimal value of a number is inputted.

B11 – This is the final display after running A11 through the formulas below

Here are my formulas: ...

## Convert Fractional Odds To Decimals

May 29, 2007

When exporting a set of historical sports results to Excel 2003 the numeric odds are converted to a date eg 7/2 changes to 07-Feb. Can this be prevented or adjusted to retain the original data.

Also if I may ask can the UK style odds be converted to a decimal style. Eg. 7/2 (UK) needs to be converted to 4.5 ( Decimal equivalent )

## Sort Mixture Of Numbers And Text Using Numbers And Decimals

Nov 13, 2013

I am looking for a VBA to sort rows which include actual numbers and text representing decomposed CTQs (or procedures in IT development)

Code:

Col A Col B
1Billing Accuracy
2Billing Time
3Credit Check Accuracy
4Credit Check Time
2.1Bill preparation

[Code]....

This is the order in which the data is copied and saved from worksheets in which they are developed. Note that 3 rows (8.1.2.1 through 8.1.2.3) are below 8.1.3 (because the three come from Worksheet 8.1.2 which came after worksheet 8.1). The first four rows came from a Top Level Worksheet. I would like to see them intermixed but in proper order.

## Convert Numeric Values With Decimals To Text

Jul 14, 2014

I have a list of numbers with decimals : such as

742111.37
703102.4
641771.52
652689.31
741202.92

I would like to convert the Numeric values to Text

Result :

Seven Hundred Forty Two Thousand One Hundred and Eleven and Thirty Seven .....
..........
..........
and so on....

## Convert Fractions To Decimals And Decimal To Fraction

Feb 6, 2009

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?

## Formula To Convert Hours And Minutes To Decimals?

Nov 21, 2013

I have a data set that expresses time in hours and minutes but it can only be exported like so:

7h10
11h03

Any function I could use to convert those numbers into 7.6 or 11.03?

## Convert Time Decimals To Hours Mins

Jan 14, 2009

I am creating a very quick holiday excel sheet where people can fill in the hours they want on which days.

I have a summery sheet too.

So if someone wants to take a full day which is 7.4 hours. How would this be represented as Hours and minutes?

## Numbers Have Too Many Decimals

Feb 8, 2009

A spreadsheet created by exporting from QuickBooks as a .IIF file is opened in Excel 2003.

A macro multiplies a cell value and returns 1.77999997138977 rather than 1.78. The 1.78 is required for importing back into Quickbooks.

Part of the code is: ...

## Recognising 1 Or Decimals As Numbers

Dec 10, 2007

I have a weird problem with Excel. It recognises all numbers as numbers but excluding the number 1. It is only recognised as text as well as a decimals, for example 3.4. So every time I try and add these values up it completely ignores 1 and decimals.

Have I modified a setting?

## Whole Numbers To Decimals & Calculate

Jul 2, 2007

I want to convert the number in a cell, G7, from a whole number into a decimal and then divide that decimal into a whole number in cell E7 and give me the quotient in cell E8.

ie:312 = 6.0
286 = 5.5
260 = 5.0
234 = 4.5
208 = 4.0
182 = 3.5
156 = 3.0
130 = 2.5
104 = 2.0
78 = 1.5
52 = 1.0

Could this also be done with the entire range of numbers from 312 to 52 and giving decimals of 6.0, 5.9, 5.8 etc.

## Numbers Are Converting To Decimals

Dec 6, 2007

I received a complaint from one of my colleague that he is facing sudden problem with Ms-Excel(2002)
The problem is When he feeds number 2 in to a cell it automatically converts in to 0.02. I tried using "Decrease decimal" and "format cells" option and even through uninstalling office and reinstalling a different version but the problem still continues.

## Numbers Changing To Decimals

Apr 4, 2008

I have received an excel file from an external source. Every time I change a number in a cell it reverts to a 2 decimal number. eg. I type in 8710 and it converts the value to 87.10. I have looked at the number formats, cleared the numbers format but I keep getting the same result. I have also e-mailed the file to someone else and everything is ok on their computer. Is there a property in the excel program that I need to change?

## Lookup Whole Numbers From Decimals

Aug 8, 2008

I 'm not sure why my custom function "minimize" is not working... I tried to do this with one of excels built in functions and would prefer a solution that way, but had to go the VBA route in the mean time. x and theta are paired together and I'm trying to reduce a select number of values x by their corresponding ratio.s It's corresponding ratio is determined by what degree value theta corresponds to. I wanted to do an if statement, but got confused...

=if((B2>=\$J2)*(B2<\$J3)) , A2*K2 , if((B2>=\$J3)*(B2<\$J4) , A2*\$K3 , if((B3>=\$J4)*(B3<\$J5) , A3*\$K4, .... etc. etc. etc........................

## Cell With Name, But Want To Remove Everything Else, Numbers, Decimals Etc.

Feb 25, 2009

I'm trying to clean up a very large list of last names. Only one individual cell, but that cell includes numbers, decimal points, and spaces inbetween the numbers. All I want left in the cell is the last name. I have just under 100,000 to do! How would I go about this? Using Excel 2007.....

## Converting Hours To Numbers, Decimals

Nov 10, 2009

How do I convert hours into numbers and/or decimals?

Example:
Column A Column B
---------- -----------
30:05:00 to 30.05
26:10:00 to 26.10
262:47:00 to 262.47

Figures under Column B refer to info that I would like to get.

## What Numbers Have No Decimals In About 500-1000 Cells

Mar 17, 2009

I use a worksheet full of formulas to know what divisors a number have, but i need to see what numbers have no decimals in about 500-1000 cells. Is there a formula whitch computer can use to see if it shows a number or not (if a number have or dont have decimals)?

## Formula To Delete Whole Numbers But Leave Decimals?

Apr 22, 2014

I've got a spreadsheet that's basically a large list of numbers, both whole and decimal. For example, let's say this is in cells A1-A5:

4
0.65
1.34
3
8.2

Is there a formula to get rid of all of the whole numbers but leave the decimals? (What I mean by that is I don't need 4 or 3 as they're whole, but I need the decimals to be left alone).

I know it's probably a really awkward question but I have over 2,000 lines to go through, it will take a long time to do manually.

Perhaps if it's not possible to a formula to delete entries, maybe just make all whole numbers say something like "NO", so that I can sort the column in A-Z order and delete all of the 'NO's quickly by highlighting them all together.

## Cell Format: Only Numbers (no Date) With Any Amount Of Decimals

Sep 8, 2009

I need a cell to restrict the input:
-Only numbers are allowed.
-No date posible.
-Any amount of decimals (they must all be shown in the cell).

I tried using the data validation and using the IsNumber() to restrict any non numeral input. The problem with this approach is that if the user enters a date; it apprears as a date format (eg: "5.May"). I'm using an european excel, where the decimal separator is a comma instead of a point; so if a user accidentaly types "5.5" instead of "5,5"; the cell will show "5.May".

I also tried the cell format/number/number format. The problem in here is that I dont know how many decimal positions will the input number have; and I need them all to be shown.

## Excel 2003 :: Concatenate Formula With Numbers With Decimals

Jul 12, 2012

I'm using excel 2003 and have a problem regarding some code.

Dit(a, b) = "=" & Hit(a, (d - 12 - e) + f) & "/" & (Pro & ".NrE.sol")

Where "Hit(a, (d - 12 - e) + f)" can be numbers with decimals.

When I run the code the result is nothing, unless the number is a number without decimals.

If I use just "Dit(a, b) = Hit(a, (d - 12 - e) + f)" it shows the right number.

## Convert Decimal To Percentage

Jul 8, 2009

Is there a method to automatically convert a decimal to a percentage?

For example:

if given the value of 76.48, is it possible to automatically convert this to 76.48%? Formatting the cell as a percentage produces 7648%. I've tried everything I know and can't get the right result.

## Convert Textbok Value As In Percentage

Sep 26, 2012

convert textbok value as in percentage, like there are two boxes on userform Ä±f second box change first box will show the result.

Sample...
Textbox1 is 500
Textbox2 if key in 50
Textbox1 will change as 250

## Convert Degrees Minutes & Seconds To Degrees.decimals

Nov 1, 2008

I had a similar problem a day or two ago in converting Deg Min.dec to Deg.dec and it has happened again. This time I want to convert Degrees Minutes & Seconds to Degrees.decimals.

The formula I am using works for a two digit number Lat. but not 3 Long.?? Here it is below:

=+IF(A2<>"",INT((LEFT(A2,3)+MID(A2,4,2)/60+MID(A2,7,4)/3600)*100000)/100000&"d","")

## Convert Numbers Stored As Text To Numbers (attached File)

Oct 22, 2009

In the ID column of the attached excel file whenever I convert the numbers stored as text to numbers it results in a weird transformation.

e.g. an ID of 480610141001 becomes 4.8061E+11. When I do the same process in the name column, which has similar numbers, it will give the correct result following the same process.

Nov 25, 2008

I was wondering what the formulas was for adding 20 percent to a price of lets say 10.00. What would I use for this?

## Macro To Convert Numbers Stored As Text To Numbers?

May 23, 2014

I have been looking through the forums and found the below code, but I have both text and numbers in the same range. I have attached an example of what I need to have converted.

Book1.xlsx