best excel format support vba excel for mac

In fact, sometimes the formatting acts like its not from this world.

My computer is set for the US region, whereas the clients computers were set for the UK region.

When I mention regional settings on my computer, Im talking about Windows and not Excel.

Back then I made the mistake of ustng Excel to change the formatting for my dates.

Contrast that with Ireland, the UK, and most everywhere else, where the date format is ddmmyyyy and takes the form DaysMonthsYears.

When formatting dates in Excel for files that may be used internationally, its wise to use date formats that begin with an asterisk () per the Format Cells Dialog box.

I can view the date June 13, 2011 in my spreadsheet as 6132011 and send it to a person using a UK regional setting on their computer and the date will automatically display as 1362011.

You want to see what they see and decide to change the cell formatting in a column that contains dates.

You select the range, open the Format Cells dialog box ( Ctrl1 ) then select English (U.K.) from the Locale (Location) drop-down list, and click OK.

You are stuck with this format in every region, whether its relevant or not.

To me 4 July, 2011 should be represented as 472011 and not as 04072011.

However thats what you get when you select the English (United Kingdom) region setting.

To do this you bring up the Region and Language dialog box, as we did previously, and click Additional Settings then select the Date tab.

Occasionally I have to work with dates formatted in the US-style.

I need my date formats to change according to the users regional settings, such as using an format as described in your article.

The problem is that there are only a couple of formats, and they dont always fit my needs, so I end up using custom formats but then they dont update (as far as I know) So the question is there a way to create a custom format that updates with regional settings (i.e.

It requires a bit of VBA and uses the Application.International property.

I am from India and here format is ddmmyyyy and data was also in this format and now, when it got exported excel is reading mm to dd.

Earlier I used to get month wise details by data filtration but now it is showing mixed aberrant results, i am totally puzzled.

I would highlight any cell that is not a 5 digit number so you can recognize it after the next step.

Short date format is like ddmmyyyy or mmddyyyy depending on your computers regional format setting.

Try the DATEVALUE Function and see if that will convert it to a 5 digit date serial number, which then you can format as a Date, then Copy and Paste as Values into the original cell.

This action will sometimes trick Excel into recognizing the Date by performing a mathematical operation on it.

This doesnt change the value.).

Best Excel Format Support Vba Excel For Mac