Kirill S. Palagin wrote:
>
> Hello everybody.
>
> I have dot (.) as decimal separator. Whenever I type "4.05" (without
> quotes) Calc "helpfully" converts this to date.
> I can not format cells as Text (or prefix number with apostrophe)
> because I need to perform calculations on that data.
>
> How do I stop Calc from being helpful?
>
> Thanks a lot.
> WBR,
> K. Palagin.
> P.S. In fact the problem is bigger than just typing - I am importing
> text files where dot is used as decimal separator, so changing decimal
> separator to comma would not solve the problem.
>
>
The problem probably arises because your locale setting treats the dot as a
"date separator" (for want of a better expression).
IIRC, the remedy when importing .csv is to use the "Text Import" dialogue.
Select the column/s containing the data in question and then, for "column
type", select "US English".
HTH.
--
View this message in context:
http://www.nabble.com/Calc-converts-number-4.05-to-date---how-do-I-stop--tf3538440.html#a9880243
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
