How to display an integer with a leading zero

[webportal]

Hello,

Is it possible to format an integer in a column that varies from 0 to 12, to be displayed as 00 to 12.

NOTE: I want to preserve this field as an integer and NOT as a text.

Thank you

[mahoneypat · Accepted solution]

You can do this by going to the Diagram View (shows tables and relationships), selecting the column of interest, under Format on right choose Custom and put in the # of 0s you want.

Regards,

Pat