Formatting a number in an expression

  • Thread starter Thread starter Michael D. McGill
  • Start date Start date
M

Michael D. McGill

I do an expression, say FieldA/10. I need the result to come out as two
digits so if result is 1 it should be 01. If result is 10 it should stay 10.
I am having a brain cramp on this one. I know I've done it before. Can't i
just use the Format command somehow?

Mike
 
I do an expression, say FieldA/10. I need the result to come out as two
digits so if result is 1 it should be 01. If result is 10 it should stay 10.
I am having a brain cramp on this one. I know I've done it before. Can't i
just use the Format command somehow?

Mike
Click to expand...
2 digits as a whole number?
Exp:Format([FieldA]/10,"00")

2 digits as a decimal number?
Exp:Format([FieldA]/10,".00")
 
Back
Top