when i megre cells that begin with zeros , I lose the zeros
when I merge cells that begin with zeros, my merged cell will not show the
zeros, how can i get around this |
when i megre cells that begin with zeros , I lose the zeros
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 |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com