Before I update to SoftMaker Office Pro 2021, I need to know if this date display error has been corrected.
I am having the same old date display error in SM Office 2018 that I have had in PlanMaker since I started using it in SoftMaker Office 2010: Though my time & date settings on my Windows 10 Pro machine are US English and Gregorian calendar - MMDDYYYY, PlanMaker always opens spreadsheets with the date format DDMMYYYY. I then must reformat ALL the date cells to MMDDYYYY. Very frustrating after 10 years of this!
Can anyone tell me if this has finally been corrected in SoftMaker Office 2021? I will not upgrade until I find out.
Thank you.
Jim
Date Display Problem
Re: Date Display Problem
In that case, PlanMaker follows date format MM/DD/YYYY as default. But you can check all the features and can experience working of SoftMaker Office 2021 by installing it as a trial which will provide you enough time for testing.
Thanks
Thanks
-
- Posts: 12
- Joined: Tue May 12, 2020 2:16 pm
Re: Date Display Problem
Okay, I saw this post and decided to try this out. I am using rev S1014.
When I type 061820 (today's date) in cell A1, right click on that data cell, select "Cell" and click on Number format / Date/Time, the result comes back as 04/02/69. Why did my data convert to the date shown?
When I type 061820 (today's date) in cell A1, right click on that data cell, select "Cell" and click on Number format / Date/Time, the result comes back as 04/02/69. Why did my data convert to the date shown?
Re: Date Display Problem
When you type 061820 in Cell A1, PlanMaker converts it into number removing zero so it became 61820 and then when you changed its number format to date it converts 61820 to 04/02/69, which is correct conversion.
If you want to show today's date(Dynamically), you can simply type =Today() and this function will place today's date or for static date type 06/18/2020 or 06/18/20 then PlanMaker will take it as a date.
Thanks
If you want to show today's date(Dynamically), you can simply type =Today() and this function will place today's date or for static date type 06/18/2020 or 06/18/20 then PlanMaker will take it as a date.
Thanks
-
- Posts: 12
- Joined: Tue May 12, 2020 2:16 pm
Re: Date Display Problem
I thank you for your explanation and additional information.
I am impressed with how well SoftMaker personnel monitor the forum and respond so quickly.
I am impressed with how well SoftMaker personnel monitor the forum and respond so quickly.
Last edited by LaurelValley on Sun Mar 06, 2022 1:52 pm, edited 1 time in total.