You could use something like:

=text(a1,"00000")&" change the format to what you need"

To keep 5 digits.

RDC wrote:

when I merge cells that begin with zeros, my merged cell will not show the
zeros, how can i get around this

--

Dave Peterson