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)

[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]