Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response