decimal

I'm using this to loop through a series of Textboxes on a Userform and enter a decimal point after the first 2 numbers entered; Dim ctrl As MSForms.controlFor Each ctrl In Controls If ctrl.Name Like "TextSTime*" Then If Len(ctrl.Value) = 3 Then ctrl.Value = Left(ctrl.Value, 2) & "." &...

I have this array formula which calculates the highest decimal place in a range. {=MAX(LEN(SUBSTITUTE($A$1:$A$9,TRUNC($A$1:$A$9)&"","",1))-1)} How can this be modified to return the lowest decimal place in a range?

Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...

I have a target sum to achieve with some constrains such as - individual numbers have a constant divisor, variable must be of 2 decimals only and sum target for 2 out of 5 data. The grand total of the row totals must be 62,185. I tried to use solver, but got stuck. <tbody> Divisor Hours Row...

Hello everybody. I need to display the result in cell (17, lc + 1) with only one decimal, but the following instructions don't work (the value remains with 9 decimals). Sheet1.Cells(17, lc + 1) = cell.Offset(0, 12).Value / cell.Offset(0, 8).Value Sheet1.Cells(17, lc +...

Hi all, MY formula is this =IF(OR(ISBLANK(E15),ISBLANK(F15)), "", "$" &E15/F15*100 &"/100g") and my result is this <colgroup><col><col><col></colgroup><tbody> $3.20 175g $1.82857142857143/100g </tbody> Issue I'm having is I would like to only have the multiplied number to 2 decimal...

Hello all, I was wondering if it is possible to create an if statement that does different things depending on how many decimal places appear in a number? For example if I have the numbers 27.23 and 30.496 can I do an if statement that multiples 27.23 by 4, but multiplies 30.496 by 5? What I...

Can anyone tell me how I might do the below multiple part scenario: I need to subtract an end time and a start time to get the hours and the minutes. Start time is in P2 and end time is in Q2. I wanted to do this in a way that I actually don't need to enter the colon and could just enter the...

I've read a few posts but none that answer the question for how to not display the decimal point: Two scenarios: 100.3897364 and 102 should appear as: 100.39 and 102 but this format shows 100.39 and 102. (with the decimal). How do I keep the decimal from appearing when a whole number...

Hello Experts, I have single column showing decimal latitude and longitude of some points and they are separated by commas. This column has multiple no of rows but the no of digits after the decimal for each entry is not static. I would like to have code that will read the latitude and...

How do I get the right function to pick up 0 as the second decimal place? I'm trying to get zero from =RIGHT(A1) where A1 is 2,366,125.60 but excel is picking up the 6 since it drops the last zero. Thanks

got this frmula here and it does work as long as my numbers are smaller than.10000 =LEFT(H29,3)&"."&MID(H29,4,1) i need to have the decimal point 1 digit from the right. at ALL times HELP

So im trying to rank my lap times but i keep getting the error that my lap time is a text value and not a number value because it has two decimal places. e.g 2.23.340 i get an error but 2.23 works. is there a way to rank numbers with two decimal places. Formula =RANK(D3:D27,LapTimes,1)...

Hello, Is there anyway to format a cell in such a way that if I enter an integer then in the cell I see just the integer, then if I enter a decimal (say 6.5) I see 6.5 in the cell, Currently I can't get the format to automatically change, I see 6 (when I input 6) and then 7 if I input (6.5)...

I've scoured the archives looking for a way to convert fractional inches or feet-inches into decimal inches and couldn't find a solution. I have column CO looking at column CN as a reference to convert the entry from inches or feet-inches (the data varies) to decimal inches and can't get it to...

Is it possible to have a Data Validation for either "NA" or a number (decimal) between 0 and 100 please? (want to avoid a list due to there being several decimal answers)

Hello All, I have what I though was a simple problem however, its becoming quite a challenge with little or no precedence on the web for reference. Ideally, I would love to have a macro (or vba) that will simply look at all of column "B" and extract the corresponding decimal value, percent...

I ran into a little oddity that turned out to be a disagreement between the Round and FormatNumber functions These results are from the Immediate window in a UDF that is interrupted at a breakpoint. The variable Value is defined as double. Its current value is the result of 5-6 calculations...

Hi dears, I would like to know the easiest way to do this in excel and I will really appreciate your help. If the third decimal place is 1 or 2 or 6 or 7 round down to nearest 5. If the third decimal place is 3 or 4 or 8 or 9 round up to nearest 5...

Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) With TextBox1 If InStr(.Text, ".") > 0 Then If Len(Split(.Text, ".")(1)) = 2 Then KeyAscii = 0 End If Select Case KeyAscii Case Asc("0") To Asc("9") Case...