Excel - Add a suffix or prefix


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


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.
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 (https://ccm.net/).
Excel - Formula based on the color of cell
Excel - Change row color on condition