The ProblemLast week one of Allen's readers asked how to display numbers differently depending on the workbook. Specifically, the reader had one workbook that should be displayed with a comma between the thousands and a comman where the decimal point goes. In the US we usually see "12,345,67". This workbook should show this as "12.345.67".
After a bit of research ("Hoew do I change this setting manually?") and recording a macro, I came up with the following. It is what I sent to Allen, with a bit of editing.