Forum Discussion
John Nedby
May 19, 2018Copper Contributor
Unwanted automatic change of text number format to scientific
I have a simple spreadsheet in which I was trying to list "codes" for keeping track of data for a game I'm working on. (Table top dice game) I find that the codes 01P2 or 01G2 can be found and repla...
Haytham Amairah
Aug 03, 2018Silver Contributor
I suggest to use Text to Column instead as the below steps:
- Select the numbers
- Go to Data >> Data Tools >> Text to Columns
- Click Next button twice to reach out to the Step 3 of 3
- In Step 3, select Text, and select a destination cell
- Click Finish
lwoosley
Aug 03, 2018Copper Contributor
Thank you! This solved my problem.