Date Changes between Formula Line and Cell

Post Reply
mtbe
Posts: 2
Joined: Thu May 09, 2024 11:25 pm

Date Changes between Formula Line and Cell

Post by mtbe »

I enter the date May 9, 2024 as "9/5/2024" in the Cell F2, but it puts the month first in the cell. It shows correctly in the formula.

I've made sure the cell format is DD/MM/YYYY, but it still changes the M and D in the cell.

How do I change this? I need to import this spreadsheet into a database that is strict DD/MM/YYY format.

File is attached to show the difference between formula line and cell F2
Attachments
Screenshot 2024-05-09 162315.png
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 3185
Joined: Wed Mar 11, 2020 5:31 pm

Re: Date Changes between Formula Line and Cell

Post by SuperTech »

Thank you for the post, but the input is always taken from the system settings and the cell format is for the output of the data only.

So, it seems your system settings is of MM/DD/YYYY and your formula line is showing “09/05/2024” (which is Sep 5,2024) and in the cell it's as per set format which is “05/09/2024” (which is May 9, 2024).
mtbe
Posts: 2
Joined: Thu May 09, 2024 11:25 pm

Re: Date Changes between Formula Line and Cell

Post by mtbe »

Thank you!
Post Reply

Return to “FreeOffice PlanMaker 2021 for Windows”