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.
5
votes
Guy LeBleu
shared this idea
1 comment
-
Sergei Baklan
commented
Such requests are at least 15 years old...