International dating format

Hello, I am having a doubt about using 'comma' in date format.

As such the third of December would be written as ‘12/03/2010’.Today this urban Texas cowboy continues to crank out high-quality software as well as non-technical articles covering a multitude of diverse topics ranging from gaming to current affairs.When you type something like 2/2 in a cell, Excel knows you’re typing a date and formats it based on the date setting in Control Panel. If you change your date setting in Control Panel, the default date format in Excel will change as well.European date format can only cause this misunderstanding when the date is of that month.The reason for this is that there are only 12 months, thus if one of the numbers is above 13 you can deduce whether the writer is using US or European date format. While this European date format is unusual for visitors, it is actually the US date format which is different with the majority of the countries in the world using European date format over the American counterpart.When you need cells in your spreadsheet to contain consistent styles, use the Google Doc’s formatting tool to change them. You can choose "More Formats" from the menu to see and select other date formats.

You must have an account to comment. Please register or login here!