Welcome to the developer List. Computers are stupid, they only know 0 and 1. We have to tell them what it is what you enter.
So we have following choice: 1) have a popup asking you what you want to enter 2) make a guess. The way we guess is the same way Microsoft does it. Because that is what most people know. Usually what users do is to preformat the cells. Or because we are all lazy write '12/24. If you start something with a ' it will marked as text and the ' is not shown. This is of course also taken from Microsoft Excel. To preformat a cell you mark it -> right click-> select option formatting-> define a format. Hth Peter Am 1. August 2018 15:54:18 MESZ schrieb Alex Perlhagen <alexperlha...@gmail.com>: >How do i turn Automatic Date off? >Automatic Date format is only causing problems. >Please have it turn off by default. > >When i write number divided by number it changes it to a date format >without asking, and changes the input value to something totally >different which is wrong because i want to calculate that division of >money. >When i write a date and change all cells format to text, the date is >shown totally wrong. > >--------------------------------------------------------------------- >To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org >For additional commands, e-mail: dev-h...@openoffice.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
