Forum Discussion
webportal
Impactful Individual
Impactful IndividualHow to display an integer with a leading zero
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
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
1 Reply
- mahoneypat
Microsoft Employee
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