You already have the answer, as you have used the YEAR function in your
previous message.
So YEAR(cell) will give you just the year from the date expressed in "cell".
---
Gabriele Ponzo
Il giorno lun 5 apr 2021 alle ore 03:46 James ha
scritto:
> How do I get the start date to be dynamically the
I’ve got a spreadsheet with all cells formatted to auto-wrap, yet when I enter
stuff into certain cells, it doesn’t autowrap. And sometimes the cell just
shows the last bit of what I’ve entered. When I right-click and check the cell,
it does show it’s set to auto-wrap.
Using LO 6.2.8.2 on Mac 1
Den tis 6 apr. 2021 kl 21:07 skrev Eric Beversluis <
ebe...@researchintegration.org>:
> I’ve got a spreadsheet with all cells formatted to auto-wrap, yet when I
> enter stuff into certain cells, it doesn’t autowrap. And sometimes the cell
> just shows the last bit of what I’ve entered. When I righ
On 4/6/21 1:04 PM, Brian Barker wrote:
At 14:11 06/04/2021 -0400, Eric Beversluis wrote:
I've got a spreadsheet with all cells formatted to auto-wrap, yet
when I enter stuff into certain cells, it doesn't autowrap. And
sometimes the cell just shows the last bit of what I've entered. When
I ri
It seems I want to set “Optimal Row Height” as the default. I thought that’s
what I had and for some reason certain rows or certain cells weren’t following
that setting. If I have the trouble again, I’ll check if the affected cell has
a different row height setting for some reason. If so, it sou
At 14:11 06/04/2021 -0400, Eric Beversluis wrote:
I've got a spreadsheet with all cells formatted to auto-wrap, yet
when I enter stuff into certain cells, it doesn't autowrap. And
sometimes the cell just shows the last bit of what I've entered.
When I right-click and check the cell, it does sho