> -----Original Message----- > From: Dave Barton [mailto:[email protected]] > Sent: Wednesday, April 28, 2021 12:30 PM > To: [email protected] > Subject: Re: Feature: automatic enter of a decimal point at a > fixed position >
> >> 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 > > You are creating an issue where a problem does not exist. I don't think so. > Using your > example Cells D1:D12 formatted as numbers with zero decimal > places means > that only integer values are entered in those cells. Fill cells D1:D10 > with the integer value 1234 and in cell D12 enter =SUM(D1:D10) which > returns the result 12,340 Right. And? In this case 12,340 means the value 12340, the "," is NOT a decimal separator but the thousands separator (in an English localised OO). But what was the question? Peter wants a solution how to enter 1234, but the value 12.34 should be taken over. Jörg --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
