Menu

Excel - Add a suffix or prefix

April 2018




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