Need A Leading Zero

[bonngo]

I need to be able to add a leading zero to a number ONLY if the number is a single digit ex. 1 needs to be 01 but 12 can stay as is. Any ideas out there?

[comment]

Try:

SerialIncrement ( "00" ; Number )

[IdealData]

Will this work? The SerialIncrement function is targeted at TEXT fields, not number fields.

[comment]

It will work, provided the result is set to type Text (numbers do not have leading zeros).

---

I should add that this will also work with a Number result (provided it's not formatted as Decimal), since Filemaker is pretty tolerant regarding what can be entered into a Number field. But eventually, if there are leading zeros then the real type is Text, and it would be better to stick to that.

Edited February 4, 2009 by Guest

[bonngo]

Perfect! Thank you so much!

[Julian L]

I know this has been solved already, but here is another way to accomplish this:

Right ( "00" & Number ; 2 )