excel spreadsheet - TechRepublic
Question
February 19, 2009 at 10:21 AM
dmauk

excel spreadsheet

by dmauk . Updated 17 years, 5 months ago

I am trying to get the cell to fill in digits to the right if missing a number of digits. i.e. If I have a number in one cell 10-200-86-570 and the next cell has 10-200-86-570-1, I want to set up another cell that will fill in the first cell so it ends up as 10-200-86-570-0000, and the next cell as 10-200-86-570-1000, meaning that I need to fill in the right side with zeros so that all have the same number of digits. is this possible?

This discussion is locked

All Comments