A few words of thanks would be greatly appreciated.

Excel - Add a suffix or prefix

Latest update on February 25, 2013 at 11:12 AM by deri58.

Issue

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.

Excel - Formula based on the color of cell

Excel - Change row color on condition