adding zeros before a number depending on the number of digits

		Microsoft Office Forums > Microsoft Excel > Excel
adding zeros before a number depending on the number of digits

11-26-2021, 07:30 AM

Pecoflyer

Windows 7 64bit adding zeros before a number depending on the number of digits

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:06 AM.