On 26/10/2007, Himanshu Ardawatia <[EMAIL PROTECTED]> wrote: > > > > > 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 >
Are you using Windows? If so, go to Control Panel > Regioanl and Language Options > Regional Options. In the middle of the pane there's a list allowing you to select the "Date separator" character. I'm willing to bet that yours is set to ".". Change it to "/" and reboot. Now try the Calc thing again. Better? If you are not using Windows, I'm sure there is an equivalent setting but I have no idea where. -- Harold Fuchs London, England Please reply *only* to [email protected]
