leading zeroes

Greetings Excel Experts, I have a problem with some materials with leading zeroes that Excel automatically trims on exporting from SAP. For example, 000100-0113 exports as 100-0113. However, when I query the trimmed value in SAP, the material is not found, and it generates and 619 runtime...

is there any way to keep leading zeros while using formula, length of number is not same for all rows, also leading zero number is not same for all some have one leading zero some have two and some have three, is there a way to keep original number while grabbing it with formula...

Hi all. I have a formula that works out column B from column A...

Hi All, I am trying to create a list of numbers in one column. My list needs to have two leading zeroes. The problem is that once the list hits 10, it takes away one leading zero. For example, excel does this:001 004 ... 009 010 011 ... 099 100 101 I would like the list to increment...

Hello, I'm using Excel 2016. I need to change numbers in the coulmns to include leading zeros. So 1 will become 001, 2 will become 002, etc. Then I want to save it as a txt file. I changed my column to text and made sure in the number section it says text. When I do a replace from 1 to 001, it...

I need to remove the forward slashes and leave the results in a data set like the below. I keep losing the leading zeros when I do a replace all with / in the find and left the replace with blank even when the cells are formatted to Text. I am working in Excel 2010 with a regular .xlsx file - I...

Hi all, I would like to concatenate a 10-digit number located in column A, a number located in column F and a number located in column G. The resulting string must be a 26-digit number. The number in column F must be 10 digits in length by adding leading zeroes (if required) and the number in...

here's my question... I have cell A1 with 10230, I want Cell B1 to show 1, C1 to show 0, D1 to show 2, E1 to show 3 and F1 to show 0. for example i tried =value(Right(A1,1)) in cell F1 but got an answer of 3 not the 0 i was expecting. please help....

I am trying to create an indexing system, that can check and create an index from a number of worksheets and forms as different transactions or events occur, the index number is created by the date formatted "ddmmyyyy" and an indexing integer at the end. example and code below. everything runs...

Hi, I'm using Excel 14.4.4 on Mac 10.9.5. I have an .xls file and one of the columns has cell values like so ... dob_062601 I want to remove the "dob_" in front of each value, but at the same time, preserve any leading zeroes that may be left over. When I do a search and replace for the...

I have numbers, some with leading zero, and I want to format the cells to text so they will stay. When I select the cells and format them to Text, I see in the number formatting group of the ribbon, that they are text. The number go to the cell of the cell, which indicates Text, but if I do a...

I have 5 digit and 5+4 = 9 digit zip codes in Excel. Some start with 0 such as 01122. Using the mail merge wizard, the zip codes that begin with zero are getting dropped, which is not what I want. I dont want it to convert a zip from 01122 to 1122, because a zip code should include the...