Share via

How to change text format change in formula bar so that is consistent with the data in the cell

Kotresh S P 20 Reputation points
2025-10-24T11:42:23.4+00:00

Hi,
How do I change the format of the data in formula bar, so it is consistent with the data in the cell. Please see the screen shot below. I want the format 5/1/2024 in the formula bar, which is date first than month.

Thank you

User's image

Microsoft 365 and Office | Excel | For home | Windows
0 comments
Answer accepted by question author
  1. riny 20,040 Reputation points Volunteer Moderator
    2025-10-24T12:45:11.11+00:00

    As far as I know, the formula bar follows your Windows system setting for dates. What you see in the Excel grid is determined by the chosen cell format. Thus, change the regional setting on your computer to use dd/mm/yyyy.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.