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