Forum Discussion
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...
JacobSanchez11 Hi, im not sure how you add that leading zeros in AN columns, difference ways of adding it will have difference outcome, if you are using number format to add it, the value of the cell is actually the value you typed in.
Here are some difference way to add leading zeros:
https://excelchamps.com/formulas/leading-zeros/
My suggestion is:
- Format the column's number as text (this way, the 0 you type infront wont disappear)
- Or if you want to type in single digits and it shows double digits, you could add a column next to AN to convert the value in AN to text using
=TEXT(AN2,"00")And then the column where you want the joined result
=CONCAT(AM2,AO2)And hide the AO columns