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...
From the look of the labels, You may also switch to date and time-values by having AO2
=TIME(0, AM2, AN2)
and format AO as mmss (ctrl+1, Custom, Type).
You will thereby have the requested look, also with leading zero on the minutes if needed, and the possibility to calculate with the results. eg MAX, MIN, AVG of column AO as well as doing charts
=TIME(0, AM2, AN2)
and format AO as mmss (ctrl+1, Custom, Type).
You will thereby have the requested look, also with leading zero on the minutes if needed, and the possibility to calculate with the results. eg MAX, MIN, AVG of column AO as well as doing charts