It is most likely the formatting of the cells.
Open the Format Cells dialog.
(select the cell range containing the date / time values and hit Ctrl+1,
or right-click and select Format Cells)
Go to the Numbers tab and select the desired format.
The Format Code you want is probably: MM/DD/YY HH:MM:SS AM/PM
On 10/9/25 11:52, Patrick Dupre wrote:
Hello,
I have an ascii file with
Date Time MeaValue
10/4/25 11:27:04 PM 43.9
10/4/25 11:27:05 PM 34.7
10/4/25 11:27:06 PM 45.4
10/4/25 11:27:07 PM 34.7
10/4/25 11:27:08 PM 34.2
that I open with calc
The 1st window is OK
correctly showing the 2 columns
Date Time MeaValue
10/4/25 11:27:04 PM 43.9
10/4/25 11:27:05 PM 34.7
10/4/25 11:27:06 PM 45.4
10/4/25 11:27:07 PM 34.7
10/4/25 11:27:08 PM 34.2
but in calc I get
Date Time MeaValue
10/04/25 11:27 PM 43.9
10/04/25 11:27 PM 34.7
10/04/25 11:27 PM 45.4
10/04/25 11:27 PM 34.7
It means that the 1 second resolution is missing.
How can I recover it?
Thank.
===========================================================================
Patrick DUPRÉ | | email: [email protected]
===========================================================================
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
