# 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.

View 2 Replies
ADVERTISEMENT
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.

View 4 Replies
View Related
Sep 25, 2009

Can 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 Related
Jan 23, 2007

How can I show a decimal as time. For example an item takes 13 minutes to make and I want to make 50, thus using 6.5 hours but really, the 0.5 hours is 30 minutes therefore, I would like to show 6:30 but Excel gets to 23:59 and goes back to 0:00.

View 9 Replies
View Related
Aug 11, 2009

=("0 "&C3)+0

have this formula for converting fractions to decimals which works great,

the problem i have is to get it to register 0 if there is no fraction in c3

will try and word my next question better

View 9 Replies
View Related
Feb 12, 2010

i am trying to convert 100.50 to 100-16, agency mortgage price formats ...

View 9 Replies
View Related
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.

View 9 Replies
View Related
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: ...

View 13 Replies
View Related
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?

View 10 Replies
View Related
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.

View 5 Replies
View Related
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?

View 3 Replies
View Related
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........................

View 2 Replies
View Related
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?

View 2 Replies
View Related
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.....

View 2 Replies
View Related
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)?

View 2 Replies
View Related
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.

View 5 Replies
View Related
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.

View 7 Replies
View Related
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.

View 2 Replies
View Related
Feb 9, 2007

I'm looking for the VBA command for this function. I tried just recording a macro in where I perform the task but it didn't record anything. Tried it several times even.

View 7 Replies
View Related
May 27, 2006

we work with both Lotus 123 and Excel 2003. Lotus will be gone next year, but for now, the official mean to publish our reports is Lotus. With my work, I copy/paste a Lotus page to Excel. I use the following macro to convert Lotus format numbers (which Excel considers as text) to real numbers:

Sub ForceToNumber()

Dim wSheet As Worksheet

For Each wSheet In Worksheets

With wSheet

. Range("IV65536") = vbNullString

.Range("IV65536").Copy

.UsedRange.PasteSpecial xlPasteValues, xlPasteSpecialOperationAdd

End With

Next wSheet

End Sub

Source : http://www.ozgrid.com/forum/showthre...087#post184087. The problem is that I need to send back this data in Lotus. Excel considers decimal numbers with a coma as real numbers and numbers with a dot as a text. This previous macro fixes that. However, Lotus works the other way. Only numbers with a dot are considered real numbers. So I would need to find a way to code a macro that converts any numbers in the Excel sheet to a number with a dot. It's a bit like doing the opposite operation.

View 3 Replies
View Related
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")

View 2 Replies
View Related
Mar 13, 2007

im working on making a price list from a pdf file. however, the pdf file has the prices in euros listed as 1.300,00 and 765,00 and 45,00 and 1.565,00 . i was wondering if there was a tool or so in excel that can change the comma and periods in the number so they read as american format like 1,300.00 and 765.00 and 45.00 .and also if there is a formula or so to convert these numbers to Dollars in another column.

View 6 Replies
View Related
Jan 11, 2007

I have a HTML table with a column with numbers like

3.6

2.5

1.8

....

and so on...

When I'm trying to open this table in Excel (.csv or if I cut n paste from HTML) Excel keeps converting it to date format.

03.jun

02.may

01.aug

This wouldn't be a problem if I could only go to Format -> Cell and choose Standard or something.

The problem is it ends up like this then:

39236

39204

39295

WTF? :D

I want this!

3.6

2.5

1.8

....

View 12 Replies
View Related
Dec 14, 2012

I'm having issues with my code for converting numbers to words I've tried a couple and I keep getting a Syntax error on

Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _

"00", 2))

I've tried a couple of different codes and I keep getting errors

yes i have enabled macros

View 2 Replies
View Related
Jan 24, 2013

I am receiving a monthly breakdown of postage costs by department but the values are received in a text format of 1 234,56.

I need to convert these to numbers.

I have replaced the comma with a full and tried to use =substitute(cell ref," ","") to remove the spaces in those numbers exceeding Â£1000 but this does not seem to work.

Postage.xlsxâ€Ž

View 3 Replies
View Related
Apr 20, 2009

How can i convert text columns to numbers in VBA.

View 8 Replies
View Related
May 28, 2012

I have 0,1,2,3,4,5...etc in Column A. How I could convert this into time format? Preferably with vba code?

Sheet1 Â AB

1001/01/2012 00:00:002101/01/2012 00:00:013201/01/2012 00:00:02

4301/01/2012 00:00:035401/01/2012 00:00:046501/01/2012 00:00:05

View 7 Replies
View Related
Aug 29, 2012

I have this value in a cell 38761.8296804781 which is displaying as 38,762. I want to display it as $38,761,829. Is this possible without going through each cell and moving the decimal point?

View 3 Replies
View Related
Jun 26, 2007

We are doing a database conversion and I have been tasked with converting all our old promotion codes to a new system. The long and the short of it is this:

I am trying to write an equation that will look at two cells (say A1 & B1) which when put together could be one of the following numbers (01,02,03,04,05,06,07,08,09,10,11,12) and translate them to a letter (A,B,C,D,E,F,G,H,J,K,M,N)

So 01=A, 02=B and so on...

I was trying to use if statements, but there are too many.

View 9 Replies
View Related
Nov 25, 2009

Do you know if you can use the cell formatting to change the sign of a number? For example, the cell contains 123.45, but I want it to show as -123.45. I don’t want to use a formula to multiply by -1, because the data is being extracted from a database and I have to do a fair amount of work on the report with the formulas to do that.

I can format the number and it shows a minus but will not use the minus if I then use it in a calcualtion. I could use a calcualtion with a *-1 in it but for ease of use by other users who may take part of the Excel report it would be better if I could format the number to negative.

View 9 Replies
View Related