when i use the concatenate formula to combine text and numbers, how can i make it show a zero in front of the numbers 1-9.
in other words,
cell A1 contains ABC, cell B1 contains 1 (even though i type in 01)
cell C1 contains =concatenate(A1,"-",B1) resulting in ABC-1
However, I would like the end result to be ABC-01, with the zero in front of the one. How can i do this?
Bookmarks