How to preset serial number in 00000# format

gmaxey · #1 03-27-2021, 07:12 AM

Does this make is simpler?

Rng1.Text = Format(SerialNumber, "00000#")

DarkNinja · #2 03-28-2021, 12:13 AM

Quote:

Originally Posted by gmaxey

Does this make is simpler?

Rng1.Text = Format(SerialNumber, "00000#")

Yes Sir... This works... Thank you very much...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking for help with creating sequential serial number on one page	4ener	Word	9	02-24-2019 07:50 AM
Add a serial number to an invoice	pringle747	Excel Programming	6	02-19-2015 11:19 AM
Copy Paste Serial No to Excel in Text format	linan123	Excel	1	05-02-2014 07:50 PM
Increase serial number for every print	atomtm	Word	1	06-15-2012 05:39 AM
Serial Number Issue	rehan5001	Excel	1	06-08-2011 02:46 AM