Expedition Expedition Navigation Software

You are not logged in. Would you like to login or register?



10/24/2024 3:31 am  #11


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 

https://ibb.co/nnX5L9S

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)

 

10/24/2024 8:36 am  #12


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 

https://ibb.co/nnX5L9S

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:::
 

10/24/2024 10:42 pm  #13


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 

https://ibb.co/nnX5L9S

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:::
 

11/04/2024 6:38 am  #14


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)

 

Board footera

 

Powered by Boardhost. Create a Free Forum


Interested in advertising here? Over a thousand active navigators and Expedition users visit this forum. Click here to contact the administrator.