Ok. I am needing the cell to contain a maximum of 10 numbers. Sometimes I am provided 4 or 5 numbers. For example "1492" or "93823". What I am needing help with a formula that will add 5 or 6 "0" zeroes before those number sets. Any ideas. I have been playing around and still can't figure it out. Thanks.