• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 108
  • Last Modified:

Excel 2010 - Date Formatting Question (Understanding symbols and formatting commands)

What do the numbers inside the square brackets mean?  There doesn't seem to be any difference between
[$-F800]dddd, mmmm dd, yyyy
dddd, mmmm dd, yyyy
Both of the above formats generate: Monday, November 07, 2016
  • 3
2 Solutions
Wayne Taylor (webtubbs)Commented:
The [$-F800] is specifying the system date format, as set on your computer. The format after it can be any date format and it will have no impact on the displayed format.

So this...

[$-F800]dddd, mmmm dd, yyyy

...will return the same date format as this...

brothertruffle880Author Commented:
Can you explain the meaning of the numbers/symbols?
There's also a F-409.
[$-409]dddd, mmmm dd, yyyy
Wayne Taylor (webtubbs)Commented:
The number is just the locale code. 409 specifies English - United States. It allows you to use the regional date format for the specified locale, regardless of what system format is on the users computer.
Wayne Taylor (webtubbs)Commented:
Question answered
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now