On 28/04/2021 10:52, Pedro Lino wrote: > >> On 04/28/2021 10:24 AM DaveB <b...@apache.org> wrote: > >> Or a more simple solution = Format Cells > > Format cells changes the appearance, not the value. How would you use Format > cells to modify the last two digits?
Go back to the issue Peter raised; "If you enter 1234 Calc will enter 12.34 in the cell". When cells are formatted as numbers with zero decimal places, typing 1234 will NEVER change the value to 12.34. The cell value will always be an integer. Dave --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
