Ricoh's Intelligent eDiscovery Blog

Michael Truelove

Tuesday Tip: Creating a Formula for Padded Zeros in Excel

Oct 22, 2019 3:43:53 PM | Michael Truelove

In a previous Tuesday’s Tip post, we explained what padded zeroes are and how to add them in Excel using apostrophes or by setting the format of the field. Today, we’re sharing an alternative way you can create padded zeros – this time by using a formula. Keep reading to see how you can do this in three easy steps, and (once you’ve got that down pat) how to combine all the steps into one single formula.

Read More

Topics: Tuesday's Tip