#1
|
|||
|
|||
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 |
|
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 |