Date formate in formula bar

Closed
phebbar Posts 1 Registration date Monday August 3, 2015 Status Member Last seen August 3, 2015 - Aug 3, 2015 at 07:52 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Aug 3, 2015 at 11:52 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Aug 3, 2015 at 11:52 AM
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
-1