"Barb R." wrote:

Let's say you have the value "12" in the cell, and you want it to be
displayed as "00012". Format the cell (or cells) as Custom with format
00000.

Thanks! :)