concatenate & custom formats
 

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?

concatenate & custom formats
 

=text(a1,"0000") & " how are you this day: " & text(b1,"mm/dd/yyyy")



Jeff Davis wrote:

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?

--

Dave Peterson