hello


i'm ron from ISRAEL and i have a question as a beginner.


i've a list of costumers. with about 5 columns.


the problematic column is the costumer number column.


at the beginning of each customer number there should be two or three zeros.


for example if it is 345 it should have two zeroes before the 345.
if the number is 3456 it should have three zeros before the 3456.


is it complicated to add the zeros to all 500 customers?


thank you
love

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

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

Sorry I misunderstood. Perhaps .
This only changes the formatting, the underlying value will not change
If you need to use the obtained string then

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thank you
i will try it very soon when i get to the computer..

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!