decimal

Hello, I’m trying to figure out how to customize specific cells to add 2 decimal places when typing a number. For instance, I would like all numbers within cell range B2:B20 to add two decimal points when typing a number. E.g. – In cell B2, if I enter 1234, I want that cell to display 12.34...

hello and thanks for helping I am trying to convert payroll hours to decimal, getting stuck when hours are over 24 example DATA in cell A1 = 30:30 would like end result in cell B1 to = 30.5 this formula is only good up to 24 hours " =(A1-INT(A1))*24 " i am open to new ideas on this thanks...

Hi everyone, Not sure if this is possible but for reasons i can not go into I need a way to change a number the was calculated in decimal into unit7 and unit 6 (so binary is unit 2 if you know what I mean :-) ) any ideas? Tony

Hello Excel community! I would like to conditionally format a column containing numeric values. For example, columns containing a number between 1-3, I would like to highlight in green. However, there are numbers with decimal places in my column, and Excel does not highlight them. For example -...

Is it possible to nest SUBSTITUTE within an IF formula? I have a column that has a range of numbers in it that I want to combine in a TEXTJOIN string. However IF the number is a decimal, I need to substitute the decimal with an underscore. i.e. instead of 6.875 it needs to be 6_875. I'm not...

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody> 12:01 12:16 12:31 12:46 13:01 13:16 13:31 13:46 14:01 14:16 14:31 14:49 </tbody> I've got 2 sets of data. One comes to me...

Please can someone help me with my query. How do i cut off the surplus numbers in Excel to show only 0.00 0.0000000000000000000000000001234567 I need the new value to be 0.00 not formatted as 0.00 Many thanks in advance

I'm a bit stumped ... when I enter "0:00" into textbox 'cu2_end' .... etc_cu2 = CDate(cu2_end.Value) Debug.Print etc_cu2 I am returned the correct value for 'etc_cu2' which is 12:00:00 AM. How can I get the decimal equivalent returned for 'cu2_end'?

Can decimal values be converted to whole numbers? 0.39 0.28 0.20 0.40 0.29

Hi If I have $0.194 how do I get 0.195? Or how do I get the third decimal spot to either be a 0 or 5 depending which is closer?

Hi everyone I have to roundup an userform decimal places to the nearest 0.25 or 0.5 or 0.75. I use the following formula but it is only to set the decimal place to two digits but cannot round up. Please can anyone help? tBox3 = Format(Round(Val(WordCount) / Range("$C$21") * 1.3, 2), "0" &...

Hi, I have a spreadsheet that performance data is imported into from two different sources. The main goal is to see when the two data entries do not match. However, the two data sources are never rounded to the same decimal place. For instance performance from 1/31/2017 will be 1.3245687% vs...

I have a test which is to see if people can correctly caluclate Log10s propperly. I have excel working it out in hidden cells. I want a cell to say "Pass" if they type the correct answer in or "Fail" if not. I have done this ( =IF(A1=A2,"PASS","FAIL")) and it all works, as long as you type in...

Hi, I would like to convert the decimal which is equal or higher than .70 to .99 For eg. 12.75 changes to 12.99 10.82 changes to 10.99 else all the other figures remains unchanged 10.39 does not change 19.69 does not change Thanks in advance Hiten

Hi there. I'm trying to reformat a number as follows. 101,015.15 should show as follows 101.015,15 with the decimal and the comma reversed. I was able to change the first comma to a decimal with custom number formatting, but can't seem to change the second period. Can someone send me the code if...

Hello, I would like to convert numbers typed into a decimal with 8 places. For example 123 into .00000123. I know there is an option in advanced settings "Automatically insert a decimal point" but I only want this to be done in certain columns. Thank you!

hello, i have a problem with my textboxes to display decimal numbers with just two (2) decimals no more, i tried this code: Private Sub TextBox75_Change() If IsNumeric(TextBox75.Value) Then TextBox75.Text = Format(TextBox75, "0.00") End If End Sub and it's not working good as you show in the...

Hello folks, I imported some data using power query>from web There are some decimal numbers there, however excel returns them as whole numbers. Anybody knows how to fix this?

This may be a silly question but if I have data that comes out of a data base in say this format..... 37.6379 and I want it to only show 37.6 (other than using the buttons in the ribbon to only show 1 decimal place) is there a formula that makes the number only be 37.6? Thanks!