Hi, I have a CSV file which has time in A.M. P.M. Format
I imported it into Calc, but the time changes to text (i.e., if I click on the cell it shows an apostrophe (') in front of the time). I am unable to convert the cell to 24 hour time format like 13:47 . How can this be done.
Importing Time from CSV file (A.M. P.M. )
Importing Time from CSV file (A.M. P.M. )
Open Office 4.11
Re: Importing Time from CSV file (A.M. P.M. )
Use Insert -> Sheet From File to import the data and in the import option dialog select Detect Special Numbers.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
- JohnSUN-Pensioner
- Volunteer
- Posts: 876
- Joined: Fri Jan 14, 2011 1:21 pm
- Location: Kyiv, Ukraine
Re: Importing Time from CSV file (A.M. P.M. )
...or apply to the already imported data Text to Columns
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Re: Importing Time from CSV file (A.M. P.M. )
When importing csv choose English import language (because of the am/pm) and always (except for rare cases) check the "detect special numbers" option.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice