Date formate in formula bar

[Closed]
Report
Posts
1
Registration date
Monday August 3, 2015
Status
Member
Last seen
August 3, 2015
-
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
-
hi Tried to change the date format in the formula bar but its not taking for ex:
29/05/2015 is showing as MM/DD/YYYY in formula bar but in sheet its showing as above and till 11/12 its taking as month instead of date ex are below please advise how to change this
06/07/2015
09/06/2015
11/06/2015

Please advise

Thanks
PR

1 reply

Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
484
Hi PR,

Sorry, but I don't see the problem.

Why would you want to format the data in the formula bar?


Best regards,
Trowa