I currently import a csv file. One of the columns contains some numbers that have four leading zeros and also some numbers that have a leading alphabetic character. When the csv is imported it drops the leading zeros. If I use the custom format it adds zeros to everything in the column. Is there any way to add zeros back to a cell containing less than 6 characters?
TIA
TIA