| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| Charting zeros as non zeros | Charts and Charting in Excel | |||
| Zeros in cells | Excel Worksheet Functions | |||
| zeros in cells | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Linear Mode
