Who is an Exel Expert
Thread Starter
Joined: Jul 2001
Aviation Qualifications: ATPL
Posts: 185
Likes: 0
From: Ultima Thule
Who is an Exel Expert
Hello there..
Can anyone help me with a small problem I have.
The problem is that I am trying to import my logbook from the online logbook website logshare.com.
The problem is that when I copy/paste the table over to exel, all numbers which are f.ex. 2.6 ( with decimal, not comma ) comes out as a date, in this case: 02. June.
I have tried over and over again different methoths of formating of the cells before I finally copy it in. It seems as exel disregards every cell that I've previously formated and puts it's own interpetation on how I want to see the information. If I try to format the cell afterwards, ( 02. June over to number ) I get even more confused.
I have also tried the export funktion of the website with the comma-separated values. However, it's even more tetious job trying to sort the information, line for line..
Is ther any other way that I'm missing..? Any help appreciated..
Proxus
Can anyone help me with a small problem I have.
The problem is that I am trying to import my logbook from the online logbook website logshare.com.
The problem is that when I copy/paste the table over to exel, all numbers which are f.ex. 2.6 ( with decimal, not comma ) comes out as a date, in this case: 02. June.
I have tried over and over again different methoths of formating of the cells before I finally copy it in. It seems as exel disregards every cell that I've previously formated and puts it's own interpetation on how I want to see the information. If I try to format the cell afterwards, ( 02. June over to number ) I get even more confused.
I have also tried the export funktion of the website with the comma-separated values. However, it's even more tetious job trying to sort the information, line for line..
Is ther any other way that I'm missing..? Any help appreciated..
Proxus
Joined: Jan 2003
Posts: 906
Likes: 102
From: Southampton
The ultimate expert.
http://www.mrexcel.com/board2/
If you can't find the answer through the search then someone will answer it for you.
http://www.mrexcel.com/board2/
If you can't find the answer through the search then someone will answer it for you.
