excel - Any function to format 5 as 5/5/5?

Question

Suppose my cell contains 5 . I want 5/5/5 in cell B of excel sheet.Like A 5 B 5/5/5 A 10 B 10/10/10 How to do it in excel sheet using any function?Any help?enter code here

Answer 1

In B1 add

=A1 & "/" & A1 & "/" & A1

and drag down (from the cells bottom right corner).