when i megre cells that begin with zeros , I lose the zeros

[RDC]

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

 

[Dave Peterson]

You could use something like:

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

To keep 5 digits.