On 04/06/2007 12:36 PM, 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. >
Right click on the cell, select format cell. What is the format of the cell set for (i.e, currency, date, text, number etc)? What is in the Format Code box? What language is it set for? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
