Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc will always parse entered content in one or another way, but you can prevent unwanted recognition as a number or as a formula by applying the format code "@" ('Text') for the respectice cells Under 'Format Cells...'/'Numbers'.
To undo unwanted recognition you have first to set the "@" format code and subsequently to use the tool 'Data' > ''Text to Columns...' with no separators set which will act as if the contents was just entered. Unfortunately you will have to use this tool one by one on the columns concerned.

Calc will always parse entered content in one or another way, but you can prevent unwanted recognition as a number or as a formula by applying the format code "@" ('Text') for the respectice cells Under 'Format Cells...'/'Numbers'.
To undo unwanted recognition you have first to set the "@" format code and subsequently to use the tool 'Data' > ''Text to Columns...' with no separators set which will act as if the contents was just entered. Unfortunately you will have to use this tool one by one on the columns concerned.
I do not know how this will work exactly on documents loaded from XLSX files. Better use the native open formats, here ods wherever possible.

Calc will always parse entered content in one or another way, but you can prevent unwanted recognition as a number or as a formula by applying the format code "@" ('Text') for the respectice cells Under 'Format Cells...'/'Numbers'.
To undo unwanted recognition you have first to set the "@" format code and subsequently to use the tool 'Data' > ''Text 'Text to Columns...' with no separators set which will act as if the contents was just entered. Unfortunately you will have to use this tool one by one on the columns concerned.
I do not know how this will work exactly on documents loaded from XLSX files. Better use the native open formats, here ods ods, wherever possible.

Calc will always parse entered content in one or another way, but you can prevent unwanted recognition as a number or as a formula by applying the format code "@" ('Text') for the respectice cells Under 'Format Cells...'/'Numbers'.
To undo unwanted recognition you have first to set the "@" format code and subsequently to use the tool 'Data' > 'Text to Columns...' with no separators set which will act as if the contents was just entered. Unfortunately you will have to use this tool one by one on the columns concerned.
I do not know how this will work exactly on documents loaded from XLSX files. Better use the native open formats, here ods, wherever possible.possible.
The procedure described may not in every case get back exactly what was originally entered.