Thread: [Solved] How to preset serial number in 00000# format
View Single Post
 
Old 03-27-2021, 07:12 AM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
  
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,429
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default
Does this make is simpler?


Rng1.Text = Format(SerialNumber, "00000#")
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote