Forum Discussion
convert numbers to text and maitain number of digits including preceeding zeros
HI I need to convert a column of numbers containing three digits (ie 001, 002, 003) into text, and maintain the zeros preceding the the non-zero digits. How can I do this? OR I have two columns...
This does not work-- puts all the zeros at the front and the nonzero digits at the end
col A col B output desired output
01 001 00011 01001
col A col B output desired output
01 001 00011 01001
Could you attach a small sample workbook?