IoTechie (opens in new tab):“Flash fill is perhaps one of the biggest improvements to make Excel easier. The option will reformat and rearrange data automatically based on your own use of Excel 2013 and auto-complete remaining data with no formulas or macros required” CRN (opens in new ...
As we have seen in the custom date formatting example, you can display Locale specific date style. I showed an example of displaying dates in Arabic style by using the custom date option in the “Format cells” dialog. You may also specify the language code in the TEXT function for display...