adding zeros before a number depending on the number of digits

Pecoflyer · #1 11-26-2021, 07:30 AM

Select the customer column
Right Click - Format Cells - Number Tab -Select Custom
In the box under "Type" enter 00000 ( five zeroes) - ok

RAINBOWONFIRE · #2 11-26-2021, 07:49 AM

i will try soon.....

but i want clarify... it should distinguish between a costumer number of 3 digits and a costumer number of 4 digits and add the zeroes accordingly.....

thanks

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