adding zeros before a number depending on the number of digits

		Microsoft Office Forums > Microsoft Excel > Excel
adding zeros before a number depending on the number of digits

12-03-2021, 11:06 PM

Purfleet

Windows 10 adding zeros before a number depending on the number of digits

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove trailing zeros from number format but only for a zero value	Matt C	Excel	3	11-22-2021 06:46 AM
Merge field return last 4 digits of a number	macquhele	Mail Merge	6	08-01-2020 11:04 PM
Entering a number of 19 digits	Jo Freeman	Excel	11	11-08-2017 06:20 AM
Having number's digits together	mohsen.amiri	Word	0	06-23-2017 01:20 AM
How to create a table with a number of line depending a number entered by user	Cellendhyll	Word Tables	3	07-10-2014 05:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 PM.