digits

Hello, I would like to find a formula to turn the right column into the left column. Is there a way to turn the word twenty four into 24? This would significantly speed up my work so I would appreciate your help! Thanks in advance.

Hi, Required a formula help to extract a records (at least which contains one number in a cell) contains a numeric values in data set Column A:C,as well same values (at least which contains one number in a cell) to be count their actual quantity from the total data set. Thanks...

I need help with how to setup a custom AutoNumber in Access. I want to be able to enter a starting number with up to eight digits and then have it increment by one. So, for example I want my starting number to be 30064889 and increment from there. Is this possible?

Hi all, I have a list of codes which can be of varying lengths ("99999" or "99999-25" or "99999R") and I would like to take the put the first 5 digits in one column and whatever comes after the first 5 digits in the net column? <tbody> Original Code First 5 Trailing Character 99999 99999...

Dear All, I am trying to convert a hexadecimal string eg <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>EAAA863573781B which should return <style type="text/css"><!--td {border: 1px solid #ccc;}br...

When pasting numbers Excel converts any digits after 15 digits to "0" so 1234567812345678 becomes 1234567812345670 I need to cut and paste from an email. Is there a way to paste so the 16th digit shows correctly (without going manual) Perhaps with a auto prefix of comma? Thanks

Hello, I have a worksheet that contains Product details (BarCode, Name, Category...) I have the following code to lookup the name reference to the entered BarCode It works well if the number is less than 10 digits Ex: if I entered this number in the "txtBarCode", it will lookup the name and...

How do I create a custom number format that always returns 5 digits? Examples: #2 = 00002 #2 2 = 00022 #2 22 = 00222

I need help to design a formula in excel to develop a unique random code, for example I have "Received" word in A1 cell then I want to get a unique Code in B1 cell, code should capture “R” from A1 cell then contain today’s current date like 011019 (01 day, 10 month, 19 year) then capture any...

i am in the need for a regex for my vba project. i need to replace the - dash that is in-between numbers only, example 1-3-1. The problem is i have negative numbers with dashes which i need to keep, but the patterm is consistent, 1-3-1, should be 1,3,1 so replace dash between digits with a...

Hi everyone, Need help with a formula. Cell A1 = 1 Cell B1 = 3 Cell C1 = 7 Cell D1 = 1 Cell E1 = 4 Cell F1 = 5 Cell A2 = 1 Cell B2 = 2 Cell C2 = 3 Cell D2 = 7 Cell E2 = 4 Cell F2 = 1 I would like to count how many digits from cell range A2 through F2 appear in cell range A1 through F1...

Hi I went to Format Cell -> Fraction and I saw the first 3 options. 1) Upto 1 digit 2) Upto 2 digits 3) upto 3 digits I entered in a cell this value 1.1 and formatted 3 cells as above, so i got this <colgroup><col><col><col><col></colgroup><tbody> upto 1 digit upto 2 digits upto 3 digita...

I have a spreadsheet of store numbers that I need to change around. The first 3 characters are always ABC, and then it follows with 2-4 digits. I need to make these all 4 digits, with the missing characters being made 0. So for example ABC1234 would stay as is, ABC123 would become ABC0123, and...

Hi, I have numbers from 1-20 in own cell and want to get a list of all number in 7 digits. Is it possible to do that in excel?

I want a way to generate any of these numbers at a time: 1234 0000 1111 2222 3333 4444 5555 6666 7777 8888 9999 I have this line below here which can check for the availability of those pins . I have been staring at it for a while now hoping to find a way around it but no success yet. I need...

Hi, I am looking for a way to verify if a cell say A1 contains same digits like 1111, 2222, etc. The Len will always be 4. Thanks in advance

I am looking for a way to add a comma after every single digit in a cell. I found some formulas on the web but since the number of digits is not equal in the cells, I can't get the result I need. For example, in column A: 12345 12 135789 135 etc. What formula can give me the result I...

Hi, I am looking to define a list in VBA and then use that list as the range in a vlookup formula. Something like the below: MyRange = Array("AA","AB") Result = Application.VLookup(Left(A2, 2), MyRange, 1, False) The ideal results would be if whatever the first two digits of the text in...

hi friends, I have the following txt strings that are not delimited and I would like to have the data separated 0120190624INIT 99999 0312345678920190621AB 000000000000000000 000000000000000000122365ABC 0310111213120190621AB 000000000000000000...

Hello, Column "D" how I have codes with single and double digits, i want a VBA which can covert all single digit into 2 digits as per result column E Example file... Book1DE1234567891011Orignal CodeRequired Result126 | 4 | 4 + 10 | 0 | 0 - 0 | 0 | 106 | 04 | 04 + 10 | 00 | 00 - 00 | 00...