Ok, I'm about to pull out my hair trying to figure out how to do this. It *should* be simple, but I'm just not getting it.

Is there a way to format a calculation field to have leading zero's? For example, if the number is "7", I'd like to see it show up as "07" in the field. If the number is "12", it just shows up as "12". All the fields that are part of the calculation are numbers.

Thanks!

I'm not sure I'm understanding you correctly, but if I am, then it may be as simple as changing your Field Type form Number to Text.

If it is something else, then maybe you can restate your problem and we can help you better.

HTH

Lee

:cool:

I have a calculation field that uses nothing but number fields in the calculation. I want the results to be forced to two digits, with leading zeros if necessary.

Here's a simplified example:

num1=2 num2=5

calculated field = num1 + num2, or "7". I'd like the results to display as "07", however.

Example #2:

num1=2 numb2=9

calculated field is "11", and I'd like the result to *not* have a leading zero in this case, so it just displays as "11".

Try:

Right ( "00" & num1 + num2 ; 2 )

Result needs to be set to Text.