G
Guest
I have two cells I want to concatenate and keep the leading zeroes of the second cell. (e.g., first cell is 201, second cell is 245 which has been formatted as "00000" to show leading zeroes and thus shows as 00245, I want to concatenate these to show as 20100245) It is only showing the original second cell when I concatenate and thus shows as 201245