> -----Original Message----- > From: TerryJ [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 07, 2007 4:47 AM > > 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". >
YES-YES-YES! This is it! Also works for manual typing if I set cell lang to "English US". WBR, Kirill Palagin. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
