> -----Original Message----- > From: DaveB [mailto:b...@apache.org] > Sent: Wednesday, April 28, 2021 11:25 AM > To: dev@openoffice.apache.org > Subject: Re: Feature: automatic enter of a decimal point at a > fixed position > > On 28/04/2021 09:59, Pedro Lino wrote: > > Hi Peter > > > >> On 04/28/2021 3:27 AM Peter Kovacs <pe...@apache.org> wrote: > > > >> I have been asked on Facebook, and I found a forum thread > if there is a > >> feature that interprets the entry of numbers the last 2 > numbers as digits. > > > >> Any Ideas, or inputs? Does LO maybe have done this? (I > could not find > >> any hints.) > > > > That is a simple calculation that can be done in two > columns. Just type the number in one column without the dot > (although I don't see that pressing an extra key would slow > down any typist) and then on the next column divide it by 100. > > > > I think this is a simple user problem, not a dev issue... > > > > Regards, > > Pedro > > Or a more simple solution = Format Cells
Really not, no formatting is able to change a value. Sure, you can compensate for this during further calculation (for example =SUM(D1:D10)/100 instead of =SUM(D1:D10)), but who wants to work like that? greetings, Jörg --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org