Format number with leading zero’s

One of the most efficient ways I’ve found to format a number with leading zero’s.

Excel: =Right(“000000000” & C2, 9)

Access:  Right(“000000000” & [Tbl_All_Accounts]![AccountNumber],9)

Interested in learning new skills?