I have a cell with a custom format of 0000 so that a 1 will return 0001 in
the cell. I am trying to use the concatenate function to combine multiply
cells into one. When I do this I lose the zero place holders, how can I
retain my format?