Padding out a cell with leading zeros
Posted by Adrian King-Cox on April 18, 2001 2:45 AM
I've got a 30,000 record database with a numeric field which needs to be padded-out with leading zeros, making the field 8 chars, i.e. 1 becomes 00000001, 11 becomes 00000011 and so on. I've tried a few complex formulas, converting to text and so on but no joy. Does anyone have any bright ideas? The completed file needs to be exported as a CSV.