Reply to thread

Message: [QUOTE="Not the expert, post: 3738528"] How do I change text to numbers then back to text? My file has 4 worksheets. Sheet 1 - Copy from the "copy sheet" - process type (text) check amt (numbers) check No.( numbers) Sheet 2 - Paste to "random sample listing" worksheet (formula set as =concatenate (g2," ,"e2," ",a2) Sheet 3 - Universe of Sample -formula =random sample listing'!h2 Sheet 4 - "Random selection worksheet - When using the Tools , Data Analysis, Sampling, I receive the error "Sampling - Input range contains non-numeric data" Is it because on sheet 1 there is a mixture of text and numbers, how can I change the text to numbers to run the data analysis, sampling then after the sampling is complete use a formula to return the text back to the text data to identify the type of process type? [/QUOTE]