I am using the Concatenate formula to merge the contents of two cells into one. One of the cells I am using contains a number and the number is formatted with a 1,000 separator (,). However in the cell using the Concatenate formula, the number does not appear with the 1000 separator. Can I somehow format this cell so that the number is formatted with the separator? Thank you!