Hi Need help on adding Leading Zero's to a cell.
I am able to achieve this at a cell level but this seemed only to be effective for viewing on the specific cell however when I combine cells either via "CONCATENATE" or "&" functions the leading zero's disappear.

Can someone who knows how to do this please share your expert opinion.

thanks

Micky