View Single Post
 
Old 11-26-2021, 01:38 AM
RAINBOWONFIRE RAINBOWONFIRE is offline Windows 10 Office 2019
Novice
 
Join Date: Nov 2021
Posts: 3
RAINBOWONFIRE is on a distinguished road
Default adding zeros before a number depending on the number of digits

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
Reply With Quote