How do I format a number with leading 0's

[Tony Williams]

I have a calculated number control on a form that I want to have leading
zeros. The control concatenates two other controls and the formula is
=[clientnbr] & "/" & [invnbr]

I want the end result to look like this

0060/0023

How do I do that?
Thanks
Tony

 

[fredg]

I have a calculated number control on a form that I want to have leading
zeros. The control concatenates two other controls and the formula is
=[clientnbr] & "/" & [invnbr]

I want the end result to look like this

0060/0023

How do I do that?
Thanks
Tony

=Format([clientmbr],"0000") & "/" & Format([invnbr],"0000")

 

[Al Camp]

If ClientNbr = 60 and InvnNbr = 23...

= "00" & CStr(ClientNbr) & "/" & "00" & CStr(InvnNbr)

Al Camp

 

[Tony Williams]

Thanks to both of you for your help
Tony