Expedition Navigation Software 
- Navigator
- Expert
Offline - Registered: 7/31/2018
- Posts: 64
Re: Change CSV logfile Utc format in Excel
iurban wrote:
i tried also on my boating pc with win10 and excel world 2016, but nothing
i am starting to feel dumb
Looks like your computer recognises the input as text and not as number. Per default in excel numbers are aligned right and text left.
Some langues use "," as decimal symbol some "."
If you either change that setting in your computer (or in excel), or change the symbol in the log file it should work.
For a quick test just replace the . With a , in a cell.
Last edited by Navigator (10/24/2024 9:14 am)
- Campbell_Field
- Moderator
Offline
- From: UK
- Registered: 9/16/2015
- Posts: 235
Re: Change CSV logfile Utc format in Excel
i tried also on my boating pc with win10 and excel world 2016, but nothing
i am starting to feel dumb
Please feel free to visit my website and for my contact details and email me the log file
:::Campbell Field::::::www.fieldyachting.com:::
- Campbell_Field
- Moderator
Offline
- From: UK
- Registered: 9/16/2015
- Posts: 235
Re: Change CSV logfile Utc format in Excel
i tried also on my boating pc with win10 and excel world 2016, but nothing
i am starting to feel dumb
Please feel free to visit my website and for my contact details and email me the log file
:::Campbell Field::::::www.fieldyachting.com:::
- iurban
- Expert
Offline
- From: italy
- Registered: 7/23/2023
- Posts: 12
Re: Change CSV logfile Utc format in Excel
Hi,
i solve the problem and I would like to share the solution.
it is all about regional setting on your pc/Mac.
excel works in different ways when import a csv and using microsoft date type
you have to use English settings to see the log file filed with right columns and rows when you import it on excel
on windows it is better have all the system with english setting
on Mac you can have custom language for specified software
last thing on log file,
I suggest to don't edit or work on log file but make a new one from expedition export function, you will have all columns and data in the right place
i want to thank you Campbell field, he supported me to find a solution
Last edited by iurban (11/04/2024 6:38 am)