> > And I tried all the options I could think of : The only ones that worked > for me were :
1. As some of you suggested, writing a number by placing a '0' at the end : eg., instead of writing it as 24.9 write it as 24.90 and it works. Doesn't change it to date format. 2. As Maria suggested, use comma (,) instead of dot (.) . Hopefuly there could be some more generic solution. Thanks Himanshu \\ ---------- Forwarded message ---------- > From: "Himanshu Ardawatia" <[EMAIL PROTECTED]> > To: [email protected] > Date: Sun, 14 Oct 2007 20:33:54 +0200 > Subject: Question about Calc > Hi, > > When I try to enter any value like 24.4 in any cell in calc (openoffice > 2.3), > it automatically converts it into a date format like 24.04.2007 which is > very annoying because I want it to remain 24.4 (or whatever the decimal > number is). Any number like 19.2 or any decimal number which can possibly > seen as a day and month....... > > Is there any configuration in calc that can help me configure it for not > considering any decimal number as a date and just let the number as it > be...unless asked for ? > > Thanks > Himanshu > \\ > > > ---------- Forwarded message ---------- > From: Frank Cox <[EMAIL PROTECTED]> > To: [email protected] > Date: Sun, 14 Oct 2007 12:40:12 -0600 > Subject: Re: [users] Question about Calc > On Sun, 14 Oct 2007 20:33:54 +0200 > "Himanshu Ardawatia" <[EMAIL PROTECTED]> wrote: > > > > Is there any configuration in calc that can help me configure it for not > > considering any decimal number as a date and just let the number as it > > be...unless asked for ? > > It sounds like you have changed your default style to something different > than > the default setting. > > Format - Styles and formatting > > Right-click on "Default", then "Modify", then select the Numbers tab and > then > click category "Number" and format "General". > > > -- > MELVILLE THEATRE ~ Melville Sask ~ http://www.melvilletheatre.com > > > ---------- Forwarded message ---------- > From: "Himanshu Ardawatia" <[EMAIL PROTECTED]> > To: "Frank Cox" <[EMAIL PROTECTED]> > Date: Sun, 14 Oct 2007 21:03:11 +0200 > Subject: Re: [users] Question about Calc > Hi, > > I tried it but then it doesn't help. > The only way any decimal number less than 31 (e.g.,22.9,12.8...etc) > doesn't > become a number in date format (eg., 22.09.2007, 12.08.2007 etc) is by > writing the number as 22.40 or 12.80 etc (i.e., by putting a '0' at the > end > of the decimal. I wonder if its a bug or any of my settings is wrong > still. > My standard setting for 'number' has options : Decimal places = 0 and > Leading zeroes = 1. > > Thanks > Himanshu > \\ > > On 10/14/07, Frank Cox <[EMAIL PROTECTED]> wrote: > > > > On Sun, 14 Oct 2007 20:33:54 +0200 > > "Himanshu Ardawatia" <[EMAIL PROTECTED]> wrote: > > > > > > > Is there any configuration in calc that can help me configure it for > not > > > considering any decimal number as a date and just let the number as it > > > be...unless asked for ? > > > > It sounds like you have changed your default style to something > different > > than > > the default setting. > > > > Format - Styles and formatting > > > > Right-click on "Default", then "Modify", then select the Numbers tab and > > then > > click category "Number" and format "General". > > > > > > -- > > MELVILLE THEATRE ~ Melville Sask ~ http://www.melvilletheatre.com > > > > > ---------- Forwarded message ---------- > From: Brian Barker <[EMAIL PROTECTED]> > To: [email protected] > Date: Sun, 14 Oct 2007 20:40:20 +0100 > Subject: Re: [users] Question about Calc > At 20:33 14/10/2007 +0200, Himanshu Ardawatia wrote: > >When I try to enter any value like 24.4 in any cell in calc > >(openoffice 2.3), it automatically converts it into a date format > >like 24.04.2007 which is very annoying because I want it to remain > >24.4 (or whatever the decimal number is). Any number like 19.2 or > >any decimal number which can possibly seen as a day and month....... > > > >Is there any configuration in calc that can help me configure it for > >not considering any decimal number as a date and just let the number > >as it be...unless asked for ? > > I don't think there is any setting to disable this behaviour. But it > is locale-dependent, so you may like to go to Tools | Options... | > Language Settings | Languages and experiment with the locale setting > and the decimal separator there. Note that these control the > interpretation of input values as well as the display. If you > subsequently change these settings back, the display but not the > interpretation is reset. This means that you may be able to achieve > something useful by selecting other settings, entering your data, and > then putting the settings back to what you really need. > > Another workaround - tedious but effective - may be to disguise the > input value so that it is the same number but cannot be > misinterpreted as a date. Your example values could be input as > 24.40 and 19.20, for example, without being misinterpreted by > Calc. (Note that this does not change the precision with which the > values are stored: all values are stored to the same precision and > are displayed according to the cell format.) As well as the > day-month cases you have described, Calc can (mis)interpret input > numbers as month-year, so you may have to be alert in order to spot > all the cases that need modified entry. > > At 21:03 14/10/2007 +0200, Himanshu Ardawatia wrote: > >I wonder if its a bug or any of my settings is wrong still. My > >standard setting for 'number' has options : Decimal places = 0 and > >Leading zeroes = 1. > > Inasmuch as you don't want it to happen: yes, it's a bug. And no: > the number setting controls only the display, not the interpretation > of input values. > > I trust this helps. > > Brian Barker > > > ---------- Forwarded message ---------- > From: "Maria Vernersson" <[EMAIL PROTECTED]> > To: [email protected] > Date: Sun, 14 Oct 2007 22:18:51 +0200 > Subject: Re: [users] Question about Calc > Why don't you use a decimal COMMA instead of a decimal DOT. That's what we > do in Sweden and Sweden hasn't been to war in 200 years :-) > > ------------------------------------------ > Maria Vernersson > Åkeshovsvägen 22 > 168 37 Bromma > Sweden > > +46 8 80 78 33 > +46 70 450 42 40 (mobile) >
