digits

I need to add all digits in a cell and the result must be less thank 10 Example - 48 = 4+8 = 12 = 1+2 = 3

https://app.box.com/s/jcxrsue4vuzhnjzqhvzdfkdon20n1sm5 In columns ABC are digits ranging from 0-9, I need a formula yes/no that tells me if the largest digit is equal to the other 2 digits.

Hello everyone, I wanted to ask if a formula or vba code could calculate the following: 1>I have a random set of digits 0 through 9 in cell range F3:F23. The digits in the cell range are in the order/sequence. So cell F3 is 1st, F4 = 2nd, etc. F3 = 2 F4 = 5 F5 = 0 F6 = 5 F7 = 0 F8...

Hello Guys, I have a cell with 4 digits number and I would like to disgin the numer to ??/?? For examples: 1455 ==> 14/55 2389 ==> 23/89 Thank you all, Omer.

I'm looking for a formula starting in K7 that will return the missing digits.The total digits are 0,1,2,3 that’s all and in row F7:H7 are my initial digits. Thank you <a href="http://tinypic.com?ref=2uegrx1" target="_blank"><img src="http://i64.tinypic.com/2uegrx1.png" border="0" alt="Image...

Hi everyone, I have starting in columns BX7,BY7,BZ7 digits ranging from 0 to 3 (0,1,2,3 ) and I wanted to count each digits as they go down by rows in separated columns. (0) starting in cell CB7 (1) starting in cell CD7 (2) staring in cell CF7 (3) staring in cell CH7 See example below ...

Hi, I've seen this thread here but it looks like the link to a working formula doesn't work. Is anyone able to help? https://www.mrexcel.com/forum/excel-questions/285670-isbn-13-10-conversion-macro.html What I essentially need to do is the following: Is there a way to have this written in...

Hello, I am curious about this phenomenon. Recently, I have noticed that Excel 2016, when I add/subtract 2 numbers that only have 2 digits after their decimal points, the number that results has several other digits after the decimals; or, it will be XXX. 00000000058620000000000. I have...

In column A I have varying input data that I need to adjust. I'm trying to eliminate the parentheses and the 1 or 2 digit numbers within. Column A I've got data like 15 C.Smith(5) 9 F.Forsberg(12) etc. the number in the parentheses increases as the season progresses. In column B I'm...

Hi guys, I am new to using excel. so here's what I'm trying to do: Some US zip codes have 9 digits and I want to a Hyphen "-" after the first 5 digits in a column. However, the same column also includes 5 digit ones so I am trying to use =IF(LEN(a2)>5,(REPLACE(a2,6,0,"-"))) but I can't seem to...

Thanks for your advice. I have thousands of lines of unique 16 digit numbers. I would like to front zero fill digits 17 thru 20. Thanks again - Tom

Hi there, I have a problem I cant quite figure out - I have two columns A & B running to 29,000 rows! In A I have codes ranging in length from 1 digit to to 7 digits. In column B are descriptors for each code. i would like to extract to two new columns the 5-digit codes and their descriptors...

To the excel geniuses: I'm working with a column with nearly 300 entries where each row has a 16 digit number. These are insurance claim numbers so i can't post the exact data but what i'm trying to do is highlight the row if the first 12 digits are the same with another column. Example...

Hi All, I need to enter values in a cell similar to this 33/35/56/65. It can be single digits or up to 4 digits and max of 20 slashes. I would then like the next 20 cells below to be able to fill in each number separately. Example: 33/35/56/65 Result: 33 35 56 65 Your help is greatly...

Hi all, Looking for a little help with this formula. My formula doesn't seem to work properly due to the "-" being used. I'm trying to extract the first four digits between "(DRILL-1) " and "-" (e.g.4106 and 4108) and place into column B and then from the "-" to the end of the digits (e.g...

Hello Friends, I need your help in finding out the formula for Data Validation. I have 2 Columns (A,B) - Need formula to validate the Serial Number. Formula condition should be Column A Should always starts with "S" and after 5 Digits it should contain "ID" and after 3 digits it should...

I've only just found out in Microsoft Word how to type a fraction in the "normal" way, that is with the digits one above the other - if .5 is wanted as a fraction, type 1 followed by / followed by 2. Then press the space bar. The 1/2 changes to 1 over 2.(can't show it here!) I have been looking...

separate the trios with 6 different digits example = 06 13 25 = we have 6 different digits. yes can not have digit repeat ex = 01 12 24 we have the digit 2 repeated no can not only to separate in a list next to trio formations without repetition of digitios...

Hello I have a string : ABC02102018 at cell A1. I need to make it looks like ABC 02/10/2018. I wrote =CONCATENATE(MID(A1,1,3), " ",MID(A1,4,2), "/",MID(A1,6,2), "/",MID(A1,8,4)). Now I would like to make my last 4 digits of string (ie.2018) into YEAR format. I tried by using year()...

I have a date in column A formatted as 1/10/2017. I am using concatenate(Year(a2),"-",Month(a2)) and it returns 2017-1. I need the month to show as 2 digits for sorting. how can I get it to return 2017-01 or if month is October, 2017-10.