Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-26-2021, 01:38 AM
RAINBOWONFIRE RAINBOWONFIRE is offline adding zeros before a number depending on the number of digits Windows 10 adding zeros before a number depending on the number of digits Office 2019
Novice
adding zeros before a number depending on the number of digits
 
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
 



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
adding zeros before a number depending on the number of digits 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
adding zeros before a number depending on the number of digits 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:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft