Right click the selected range and choose the Format Cell s item from context menu. Convert a Number to Text Using Excel Concatenate. Click the Insert tab and click Module.
Essentially the function will convert a numeric value into a text string.
Therefore if you concatenate an empty text string and a number this returns a text string containing just the number. RANDBETWEEN function returns random numbers between any two numbers. Essentially the function will convert a numeric value into a text string. This works because when you select Paste Values it pastes only the values from the source cell and not the original cell formatting.