concatenate & custom formats

[Jeff Davis]

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]

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