By the way, Sheet 3 would not import from Excel as QP did not like the (=Bible!A32) format. I had to copy & paste some of the data and use trial and error to figure out what QP's format was (+Bible:$A2). In Column L, the date is part of formula that adds the date from B with K which results in the approximate date I will finish reading the book.
FYI. When I open my reading file in QP, I can right click and change the date but once the file is saved and then opened back up, it reverts to the default. Plus when I go to the custom area and ADD a different date format, the same happens. When I save the file and then re open it, what I did had vaporized. In addition, I have made this changes and saved the file as a QP format and it does not stay. And I have tried this on two laptops (both Windows 10 with Word Perfect Office X8) and got the same results.
In conclusion, I can live with the date format (12/05/16) but why should I have to. I started with Dos (which dates me) and liked Supercalc but it, like many other programs, did not survive the move to Windows. I tried Lotus 123 and then it went away. I have worked with Excel but would like to make QP work if possible. I have used Microsoft Office 365 for the two years, but really do not want to continue. I have done it because I get spreadsheets from clients and others that require an excel spreadsheet, which is where I began to take a fresh look at QP. LibreOffice cost me $.01 from Amazon but I do not need its word processor and more, and it really does not like Excel 2016 format, although it accepts the date formats.
Any suggestions from you are more than welcome. My annual fee for Office 365 ends in January.
Good Morning, Charlie. If you open my spreadsheet you can see that Sheet 1 (Library) contains the date that I start reading a book and when I finish. In Sheet 2 (Reading) I have 3 dates. In Column B, I want the date to be (ddd, mmm. dd or Mon, Dec. 5). In Column L, I want it to be (month dd, December 5). In Column N, I want the date to be (mmm. dd, Dec. 4). There is no major necessity for this other than it is very easy to do in Microsoft Excel or Libre. In Sheet 3 and Sheet 4, I tried & succeeded in moving the text from Sheet 4 (A2) to Sheet 3.