cells switch formatting from text to general under certain conditions

["badpenny" <badpenny edawizardry com>]

Greetings,

version 1.10.17

I need to export decimal numbers that may end in zero.
I need to preserve the lagging zero ie no rounding to integer.

2.0
2.1

I tried formatting the column explicitly as "text" - lagging zeros are
preserved and values are left-justified UNTIL you close/reopen the application
- values are now right-justified and lagging zeros and decimal points removed

2
2.1

and upon export

2
2.10000000000000001

Is there a way to tell gnumeric to not interpret the contents of a cell in any
way? "text" should work but in this case does not.

Regards,

Chris



--
I hate spam