I have some numeric values that have leading zeros. Some have one and some
have more than one. I want the leading zeros to show. I know that I can
type in an apostrophe in front of the numbers and the leading zeros will
display. The only problem is, I want to use this in a calculation. I also
know that you can custom format the cells. But in this case, when I don't
know how many leading zeros I'm going to have, how would I customize the
cells?

Thank you, Karen