I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.
A colleague was recently working with a client who was preparing data for import. One of the issues they encountered when cleansing the data was that Excel stripped the leading zeros from the ID fields and were looking for a way to add them back in order to import the…
Continue Reading Ian Grieve’s Article on their blog
Excel Snippets: Pad Numbers with Leading Zeroes
I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. A colleague was recently working with a client who was preparing data fo…
Blog Syndicated with Ian Grieve’s Permission