Question: A1 and B1 are combined and reversed. B1 uses custom format of 0000- to go from 1 to 0001-. Result is 1-CB. How do I get C1 to come up w/0001-CB.
Concatenate joins text strings together and so if you want a number in a particular format you must tell it that and the best way is to use the Text() function