Excel - Add a suffix or prefix

July 2017




Issue


I need a formula that will add a zero at the end of a 4 digit number in each cell.

Solution


Use this formula:
Let say value is in A1, then in B1, use (to add zero as suffix):
=LEFT(A1 & "00000", 5) 

To add zero as prefix:
=RIGHT("00000" & A1, 5) 

Note that


Thanks to rizvisa1 for this tip on the forum.

Related


Published by aakai1056. Latest update on February 25, 2013 at 11:12 AM by deri58.
This document, titled "Excel - Add a suffix or prefix," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).