False True 6 Detailed Calculation Settings True 0 0 dialog False vertical 12 False end _Help True True True True True True 0 True _OK True True True True True True False True 1 _Cancel True True True True False True 2 False True end 0 True False 0 none True False 6 12 12 6 True False Conversion from text to number: True comboConversion 0 0 0 Treat _empty string as zero True True False True True 0 1 2 True False Reference syntax for string reference: True comboSyntaxRef 0 2 True False Use formula syntax Calc A1 Excel A1 Excel R1C1 Calc A1 | Excel A1 1 2 True False Generate #VALUE! error Treat as zero Convert only if unambiguous Convert also locale dependent 1 0 Apply those settings to current document only True True False True True 0 3 2 True False Contents to Numbers False True 0 help ok cancel Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values. This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO 8601 formats.