Hi everybody,
I am generating the random numbers through randbetween() function in a cell. Is there any way to increase the spaces between the digits of the obtained random number within a cell. For example if I generate randbetween(100,9999), I get the random number 3729 while I want this number to be appeared like 3 7 2 9 in the same cell so that I can treat this as a single number in a cell.
Please don't suggest any vba code since I will not be able to understand that.
Thanks in advance.
Bookmarks