[Calc] - How can I stop all NUMBER FORMATING? (allow raw text input only)
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
Just a remark: By default a cell decides "autonomously" whether an entered/imported sequence of keystrokes/characters is meant to be a number or text. "Recognition" as an entry of type 'Number' also assigns a numeric format (guessed automatically) then to the cell. "Supposedly no numeric intended" results in assigning type 'Text' to the content, not to the cell. Next edit, next "recognition".
The fake 'Numbers' format 'Text' ("@") applied to a cell skips the "recognition" simply. Since this also is suppressing the recognition of an entered string as a formula, Cells treated this way cannot calculate and display formula results.
Like so many smart features automatic recognition made a big mess. Do you need proof?