Forum Discussion
Leading zeros
Hello all! I have a sheet on which I paste from a website. The values are times with three spaces for hours (hhh:mm:ss), the problem is that I need to sum up the values in a column, and for some ...
Itzel_Samaniego You can remove the leading zero using the following formula, when doing this Excel will automatically recognize it as a time value.
=RIGHT(A1,LEN(A1)-1)