Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In 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 #,##0.

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?

share|improve this question
up vote 0 down vote accepted

Actually, creating a macro to do this was painless, here's how to do it in 3.2:

  1. Select Tools -> Macros -> Record Macro
  2. Select Format -> Cells -> then select required format and click OK.
  3. Click Stop Recording and give the macro a suitable name.
  4. (optional): Test the macro by selecting some cells and selecting Tools -> Macros -> Run Macro -> then select your macro.
  5. Add the button by right-clicking on the toolbar, then Customise Toolbar -> Add -> Macros -> and select your macro.
  6. Optionally you can assign an icon to your button via Customise Toolbar -> select your macro from the Commands list -> Modify -> Change Icon.
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .