In OpenOffice.org Calc I very often want to format numbers with a thousands separator.
How can I create a toolbar button to do this?
Via the menus, the appropriate format can be applied with Format -> Format Cells -> Number, and the number format is
However I'd like to be able to add a button to the formatting toolbar to do this (via right-click on toolbar -> Customize Toolbar). Unfortunately, there doesn't seem to be a pre-defined button for this - though there is "Number Format: Date", ..."Add Decimal", ..."Currency" etc.
Having done this a very long time ago in Excel, I suspect the solution would be to create a macro to do this. If so, how do I do this? Or is there a simpler alternative that I've overlooked?