Forum Discussion
JacobSanchez11
Feb 23, 2024Copper Contributor
Leading Zeros
I am attempting to CONCAT the two cells as seen below, however, when I CONCAT it will drop the leading zero from the second cell when I need it to remain to show as 1300 instead of 130. How can I kee...
Detlef_Lewin
Feb 23, 2024Silver Contributor
=TEXTJOIN("",TRUE,TEXT(AM2:AN2,"00"))