I can not work out how to stop Clac from automatically formating number strings…
Basically I am working with Tab- delimitered Text files to be read as a data source by an application I am working with. One of the columns is supposed to be a numbered order list…
1.001
1.002
1.003
…
1.165
2.001
2.002
2.003
etc etc
But no matter what I do it comes out with formatting… so stuff like this happens…
1.010 → 1.01
1.600 → 1.6
I know this is mathematically correct but it is NOT the data I need in the application.
These I have tried these solutions found on this knowledgeable and THEY DO NO WORK
I have gone to Tools/Auto-correct Options and unticked everything in “options” and “localized options” as well as unticking “autoinclude” in “exceptions”. This changes nothing.
If I use a “,” at the start of the data input “,1.600” then it appears correctly in the column as I want it, but with the “,” at the start… thing is when upi export the text file this command is not removed and the data is no good as all the numbers in the column have a “,” at the front.
Question
Surly there is a way to just make it STOP doing anything and allow raw text inputs into the columns?
Thanks in advance