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...
Twlowe
Nov 06, 2023Copper Contributor
It doesn't work when parsing.
1234-1E001 becomes two colums with the scientific equivelent of 1E001 in the second column no matter if you choose text or not. I tried to trick it and chage all the 1E to '1E before and then after parsing change it back by using find and replace. Then when I used find and replace it changed the cell format to scientific and displayes the number as 1.00+01 and it NEEDS to be 1E001, that is the number. How do I fix this?
Twlowe
Nov 07, 2023Copper Contributor
I missed that you need to select both colums separately to set the format. I just changed the first column to text the 2nd was general. it works now when I select the destination column for the number and change that one to text.