Offer an option to allow for different locale formatting in a single workbook
My Windows regional settings are FR-CA, so Excel, very smartly, formats numbers and dates accordingly. But, at times, I have to prepare and print reports with numbers and dates formatted according to US settings.
That gets done on a cell by cell basis, by choosing the format I need among the many choices offered by Excel. And it works, but it's very tedious.
I wish it were possible to associate specific regional settings with a sheet within a workbook, so that numbers copied from one sheet to another got formatted (and dated) according to the (different) settings set for that sheet.
Sergei Baklan commented
Such requests are at least 15 years old...