Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 #,##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
add comment

1 Answer

up vote 0 down vote accepted

Actually, creating a macro to do this was painless, here's how to do it in OpenOffice.org 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 -> OpenOffice.org 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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.