Suppose you 4-digit number are in Column A, starting from row 1. You
could insert the following formula in cell B1 and drag to final row:
="0" & A1

This way your cells will actually have a leading zero. If you just
format the column, the leading zero is only visible in cell and not
actually inserted before your numbers. If you only want to view
leading zero, prefer Bob's suggestion, if you want to manipulate your
cells in other formulas and want them to have the leading zero, prefer
the above formula.

Best.

http://www.exciter.gr
Custom Excel Applications and Functions!


On Nov 3, 12:03 am, Jenilise
wrote:
I have a spreadsheet with over 1000 CSI codes that are only 4 numbers. The 4
numbered CSI codes all need a Zero in front to make it a five digit code. Is
there an easy way to just globally add a zero to just these 4 digit codes?
Example:
Wrong codes How I want them to look
2515 02515
2351 02351
7524 07524

Just hoping there is a way to avoid having to go into each cell and add a
zero.
Thanks for your help