Hello. When using the "&" character to join a text (say, in cell A1) with a value from another cell, is there a way to format the value in cell A1 after it has been joined with the text? For example, is there a way to format the number in cell A1 to appear as (1,000), instead of the default -1000? Thanks for you help!