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)
Thanks to rizvisa1
for this tip on the forum.
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