digit

Dear Sir, I want to insert comma (,) in the number like as standrad format of amount. In standrad format 1 million write as 1,000,000.00 but I want to write 10,00,000.00 ( this comma sepration is done in Nepali Amount). First Comma is inserted after 3 digit like as Standrad Format (English...

hi guys i have a question about my userform i got 1 command button and 16 textbox. the textbox 1 was the one that i use to search the data and display it to other textbox. is it possible to textbox1 to search only the last 3 digit number instead of 8 digit? wish some can answer my question...

Hi folks Every year I have to generate a list of 4 digit safe codes, for 60 sites, that change monthly. The safe codes cannot have repeating characters. So I have 60 rows, 12 columns. Each cell must have a code between 0123 and 9876. They need to be randomly generated. It doesn't have to be...

Hi All I have the following formula that references a row that contains a two digit code, that then automatically imports data into another worksheet based on that two digit code. The problem I have is that this two digit code can be GD or Gd and mean two different things. Am I able to...

Hi i need a formula of a excel file that converter my 13 Digit ISBN to 10 Digit ISBN i am from India Help Thanks

Hi everyone, Need help with creating a formula: Digits = 0 through 9 Cells P4 through R4 are the most recent digits Position 1, Position 2, Position 3 Trying to calculate how many rows back when all 3 digits 9, 5, 4 appeared. So using the example below. The 5 & 9 (from cell range P4 through...

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

I have a formula which has worked perfectly for some time, but I now have some variables in my source data and am struggling to amend it. Essentially I need to search a string of text and return a 10 digit number. Previously this always started with a “41” so I could use the formula...

Hello, I have a formula that my employees use (and have problems with) frequently that I am trying to formulate an excel spreadsheet for to remove the human error. Most of the formula is very straight-forward, but the last part is causing me issue. So the formula spits out a number and you have...

Need to change a 3digit text value to a 3 digit value?

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

How convert 13 Digit ISBN No to 10 Digit

I have column C. I would like a formula please to give me a result of - if the last digit is a number then yes, if the last digit is a letter then no. Thanks.

Howdy, In column A is a list of numbers. What formula should I use to list the first only 7 numbers in column A, whose last digit is 8. Thank you.

how can I format a number in vba below 101.00 = 00101000 90.00 = 00009000 25.50 = 00002550 2300.50 = 02300500 whatever number i use, must have the same 8 digit format.

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

please !, separate last digit, create a field to type the strings then confront with which lottery hit 80% or more ojetivo = play the same string in several lotteries

I tried all of these formulas and none work for our example from this page: https://www.mrexcel.com/forum/excel-questions/310146-calculating-upc-barcode-check-digits-3.html I am using the GS1 as a guide, as they are the rules of barcodes :) Formula Name Product Name Partial UPC...

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

=AND(F13="",LEFT(H13,4)="0") =AND(F13="",LEFT(H13,4)=0) Both formulae are not working. I want the formula to highlight the cell if the two conditions are true. The corresponding cell in colulmn F is blank and, the 5th digit the from the left or 4th digit from right, (always eight digits...