When I convert a Number formatted value to Text format I see that the number
just looks like it's formatted as text. I have to then double click on it
or edit it some how then click away for it to be saved (stored) as text.
For the "inbetween" state before it gets stored as text if I resize the
column to make the column smaller then the number is wide the number will
change to scientific notation. Where as if it is a Number format it turns
to ####..., and if it is stored as text the overlapping part either
disappears or lays on top of the next cell to its right. Is there a way to
change the inbetween state so that it does not get converted to scientific
notation and acts like one of the other two ways?
Thanks,
Nate