The formula bar displays the actual value in the cell without any formatting.
In the case of a date it will appear in whatever format your system is set to use for dated.
Why do you need the date in a specific format in the formula bar?
It would be possible to do so but then you might have problems when trying to use the value in calculations/comparisons etc.
Bookmarks