Solved Need to add 0's before number if value is less than 9 chars

Microsoft Office 2010 professional
September 30, 2013 at 05:45:51
Specs: Windows XP
I see on data validation that I can set a cell length but when transferring from other programs, sometimes I loose the first couple of 0s which are frequently the first characters in a customer number. These numbers will always be 9 characters so if I loose two or three characters I need Excel to add them back.

Would a formula work better for this? And what would I need to do?

See More: Need to add 0s before number if value is less than 9 chars

Report •

September 30, 2013 at 06:01:28
✔ Best Answer

Report •

September 30, 2013 at 14:50:17
You could also do a Custom Format:

Select your cell
Right Click,
Select Format Cells,
Select Custom,
Then in the Input Box, below the word Type:
delete the word General and enter 000000000 as the format.


Report •

October 1, 2013 at 05:40:26
Thanks to both of you! I used the TEXT that DerbyDad suggested but will keep that custom formating idea for future reference, Mike. I appreciate both of your responses.

Report •

Related Solutions

Ask Question