Thread: adding zeros before a number depending on the number of digits
View Single Post
 
Old 12-03-2021, 11:06 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
I have had to do this for the last 20 years on SEDOL codes and this works perfectly

=REPT("0",5-LEN(J16))&J16

Probably my fav formula!
Reply With Quote