Date formate in formula bar [Closed]

Report
Posts
1
Registration date
Monday August 3, 2015
Status
Member
Last seen
August 3, 2015
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 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
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!