Hello, Just an FYI - I realize that this is still being worked on - however I would just like to express my frustration with this issue. I routinely use files created with MS Excel (2003 format) and if I open a file created with Excel that has dates formatted as MM/DD/YYYY, Planmaker (Revision 505) will always scramble the date formats and reverse them as DD/MM/YYYY.
Also, PM puts a leading zero in the month/day of the date whereas Excel does not. If I save the opened Excel file using Planmaker, the date format gets scrambled and ends up as a "custom" format in Excel which then keeps the leading zeros. I can select the dates and re-format them but this is a real pain in the you know what. This is not acceptable (in my opinion) when I have to send these files to other Excel users.
I love the software, but hate these seemingly obvious issues that have not been resolved within the software. Please see my capture for clarification. I realize that the issue is being worked on, but it is a major drawback to using Planmaker for me.
Date differences.png [ 51.36 KiB | Viewed 1949 times ]