digits

Hello - I'm trying to create a column(F) in which the user would need to enter their 9 digit social security number without dashes. Therefore if they enter a dash, or don't enter the full 9 digits they should be prompted to do so with a pop up. I tried data validation and entered the...

Hi, we are trying to find a macro which would replace the alphanumeric contents of each cell with: -letters with "L" -digits with "9" -any other remaining characters with "_" Example: <tbody> XC/73:54-15PC 44C becomes LL_99_99_99LL_99L </tbody> Best NEil

Hi Guys. Could really use the help. <tbody> a b c d 1 item 1 100000 100 10000000 2 item 2 20000 20 20000000 3 item 3 30000 3000 30000000 4 item 4 4000 400 40000000 </tbody> Basically, I will copy paste item prices from a sales sheet onto a blank sheet. The maximum length of a...

Hi all, Can anyone help me out for the below requirement. > I have dates in Column S wherein i want to copy only the year (which is last 4 digits) from Column S and paste it in column T. > I need to use the used-range based on Column A. Please see below example. <colgroup><col...

I have a spreadsheet where i have four columns (B, D, E &F) which hold info which i need to concatenate to create a unique reference number. The issue i have is that the first column contains text, the second & third contain two digits and the fourth contains three. The second, third & fourth...

Good morning Mr. Excel Community, I need help to create a custom cell value format to show my input (4 digit number) as "##'-##" (Ft'-In"). I've done some research on the rules/boundaries for creating custom cell formats within Excel & how to add text to a numerical value, but I have not been...

Hi, I have a .csv file and it is filled with numbers between 0 and 1. There are about 15 significant digits in the file. The issue seems to be that when I save the file (copy the values to excel then save as .csv) the .csv is truncating the digits to 10 places. Is there anyway to keep the...

Hi experts, I need some help please, Column E is populated with 10 numbers (E1-E10) In B1, C1 and D1 simple digits. I'd like to get in Column F a new list with the numbers that have only one of the digits given in B1 C1 D1.Ex B1=2, C1=4 D1=5 Column E= 021, 035, 187, 292, 425, 328, 654, 768...

I've seen the post to find (6 consecutive numbers adjacent to each other in the string) with the solution being: =LOOKUP(10^6,MID(A1,ROW(INDIRECT("1:"&LEN(A1)-5)),6)+0) I am trying to find the first 3 digits in a string like this: text 777 moretext 555. When I apply the solution above and...

Id like to format a cell that is the result of two other cells. There should always be 5 digits to the left of the / and 2 digits to the right of the / . Cell1 Cell2 Cell3 (Result) 1234 1 01234/01 34567 2 34567/02 Thank you in advance Al

Hi All, Quick question. I want to generate a list of random numbers each 125 digits long, including zeros, with a full output - not reduced to an E+ number. Excel seems to have limit on the RAND and RANDBETWEEN after about 17 digits. Any suggestions appreciated. Thanks,

I get data from various sources and have to create user login IDs that are consistent. I would like help getting one formula (not a macro) that will create the correct ID for all of the different scenarios. Here are more details: User ID requirements: All numbers (no letters or other...

Hi all, I have the following, (a partial list). <colgroup><col></colgroup><tbody> 1220160070029210 0620180070029213 0120170070029213 1120160070029210 0420170070029213 </tbody> I need to first 6 digits as for example, Dec-16, Jun-18 etc. I can not use =LEFT(F4,6) There must be an...

Hello - Is there a way to customize a column of cells that requires 9 digits (no more or less) and no dashes? This column will be used to enter social security numbers. I was able to customize no dashes, however, not sure how to require 9 digits in addition to no dashes.

Hello, I am working on taking data from one sheet, and saving into a new format to push into computer system. Our job number format is W1234[year][-rev#]. i need to remove the year# (and -rev if it exists). This will be used to populate other cells which do not care about the full W#. I...

Hi, I'm looking for a formula that will separate the digits from a whole number, into single cells. In cell AM6 I have the number : 5780 then I need starting in cell ; AO6, 5, AP6, 7. etc... Numbers are from 1 digti to 5 Digits long. Thank you. Serge.

Hi everyone, I'm looking for a formula that will extract, all the digits used in a series of 5 number, minus 1,2,3. See example below. Thank you.Excel WorkbookDEFGHIJ58273235385788619102328089752027273000577Sheet

can anyone help me to gets the 6 digits code from digits 0-9 i really need it badly

separate cracks without typing example 18 20 36 = yes for 6 digits without repetition 18 20 38 = not because there is a repetition of the digit 8 there can not be in the separation of the cracks, cracks with repetition of digits including zeros...

Hi good people, please help me with a formula that will return the MODE of only the first digits of an array of numbers, for example, if I have in row 1, columns A-E for example: 12345, 32647, 36143, 41345, 53261, I would like "3" returned. Thank you kindly...