On 2022/08/09 14:53, Johnny Rosenberg wrote:
Den tis 9 aug. 2022 kl 12:26 skrev Hylton Conacher (ZR1HPC)
On 2022/08/08 22:19, Johnny Rosenberg wrote:
> Den mån 8 aug. 2022 kl 21:47 skrev Hylton Conacher (ZR1HPC)
> <email@example.com <mailto:firstname.lastname@example.org>
> Using LO Calc 22.214.171.124 and I have a 28 column table RAW Data
> excess of 65k rows. A three column sample below:
> Date Simple Date
> 2022-01-01T00:05:00+02:00 2022-01-01 00:05:00 17.5
> 2022-01-01T00:00:00+02:00 2022-01-01 00:00:00 17.4
> Are those dates numbers formatted as dates or just text?
The Date column is formatted as number and the simplified Date is
formatted as text.
Is VLOOKUP fussy about the format of the cells it must search? I
it is just matching a string of characters?
It's not fussy about the format, but rather about the actual value in
the cells, because if it's formatted as a date, it's really just a
number (0.0 = 1899-12-30 00:00:00 and so on....
The tab called Raw Data is actually a .csv import of an external file on
which I have no ability to determine how the columns are formatted.
As time progresses so I will download another .csv file and overwrite
the existing one with an updated file.
The bits that contain any formula will remain unchanged, apart from
having their ranges extended due to the additional rows added.
But I wonder about the other column that is formatted as text. What do
you mean by that?
I clicked on one of the cells in the Simple Date column and selected
'Format->Cell' and it returned that is how it was formatted.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy