At 16:44 05/05/2023 -0400, James Lockie wrote:
That explains my test spreadsheet and I fixed that in the test and it works.
Incidentally, one easy way to spot that what you have is text and not
a proper date is that by default text is left-justified - as in your
original test file. True
That was it but it happened because I copied a file with 2023 dates to a
new file and then replaced 2023 with 2024 (replace all, selection only)
and it loses the formatting (resets to the formatting in A1) in W1.
On 2023-05-05 17:12, Brad Rogers wrote:
On Fri, 5 May 2023 17:09:37 -0400 (EDT)
On Fri, 5 May 2023 17:09:37 -0400 (EDT)
James wrote:
Hello James,
>be the date in the first cell but only display the month.
Currently, the formatting clones cell A2; You need to change it.
--
Regards _ "Valid sig separator is {dash}{dash}{space}"
/ ) "The blindingly
I want the date in the first cell to display as day month year but the sec cell
be the date in the first cell but only display the month.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
On Fri, 5 May 2023 16:44:49 -0400
James wrote:
Hello James,
>My original doesn't work and is definitely a date.
Because you've got the formatting wrong in the second cell.
--
Regards _ "Valid sig separator is {dash}{dash}{space}"
/ ) "The blindingly obvious is never
That explains my test spreadsheet and I fixed that in the test and it works.
My original doesn't work and is definitely a date.
I deleted mostly everything from the original and uploaded it (same file
name).
https://www.mediafire.com/file/19yqomh4pp67cy7/2023-05-05-test-ods.ods/file
On
At 15:41 05/05/2023 -0400, James Lockie wrote:
Does this work for you? The A1 cell contains a date with a date
format (NN, MMM D, ) that displays the weekday month day year.
The B1 cell contains a reference to the A1 cell but has a date
format () that is only supposed to display the
Den fre 5 maj 2023 kl 21:49 skrev James :
> Does this work for you?
>
Yes, I believe it does.
>
> The A1 cell contains a date with a date format (NN, MMM D, ) that
> displays the weekday month day year..
>
fr, maj 5, 2023
> The B1 cell contains a reference to the A1 cell but has a date
Does this work for you?
The A1 cell contains a date with a date format (NN, MMM D, ) that
displays the weekday month day year..
The B1 cell contains a reference to the A1 cell but has a date format
() that is only supposed to display the month.
I uploaded a sample file to: