I am trying to merge two cells into one and know how to do this nice and easy, my problem is that numbers below 100 (ie 001) loose their "0"'s.
Example:
Cell A1 - "AAA" Cell B1 - "001" Cell C1 - =A1&"-"&B1
Cell C1 should show "AAA-001" but it only shows "AAA-1"
Cell B1 is formatted to be a number showing 001.
I have tried using CONCANTATE and TEXT but to no avail. Anyone know how I can make excel produce the result "AAA-001"?