Quote Originally Posted by davieddelacruz View Post
Thanks so much. Now, I'm curious about the regional settings thing since mine is using it based on the formula you provided as well. What's the reason for that? And how can I change it to USA settings?
You're welcome and thanks for the rep.
If you're using Windows, the easiest way to check/change your regional settings is something like this (the instructions below are correct for Windows 7 - they will probably vary a bit for 8/8.1/10 but shouldn't be too different):
1. Open the Start menu;
2. In the search box, type 'Region';
3. One of the results found (hopefully the top one) will be 'Region and Language' - select it;
4. In the window which opens, you have two options:
a. change the main 'Format' to 'English (United States)' which will change all your settings to USA standards;
b. leave the main format as you have now and click 'Additional Settings' to change the 'Short date' format from some variation of d/m/yy to whatever format of m/d/yy you'd prefer (mm/dd/yy or mm-d-yy or whatever).
(You'll see that there are options for changing your preferred time format, currency, etc as well as date.)

Hope that helps.

(If you're using something other than Windows, then I'm sorry but I can't help with that.)