When I concatenate two cells, containing "Jan" in one, and "56.0540" (as a numerical format, with 4 decimal places), I get: "Jan56.054".
I would like it to display as "Jan56.0540" (with the trailing zero). I have tried a number of things but cannot figure out how to get this to happen. Any suggestions?
