At 12:28 12/06/2007 +0200, Guido PAUELS wrote:
I want to use the windows settings for the general number format and
i defined it to be "x xxx.xx" (block separation = ' ', decimal
separation = '.').
How to i make OpenOffice recognize this default format or how to i
set it to be the default number format in OpenOffice?
regards
Guido PAUELS
To format cells in Calc in the way you require, go to Format |
Cells... (or use right-click | Format Cells...) and choose the
Numbers tab. In the Format code box, enter:
# ##0.00
or
# ##0.##
depending on whether or not you want the digits after the fractional
separator to appear even if they are zero. You can extend this idea
to the left for longer numbers if necessary.
I don't know of any way that you can make this the default format,
but it is quite easy to apply this user-defined format to large areas
of a spreadsheet, such as multiple rows or columns - or even an
entire sheet - by selecting these areas and returning to Format Cells
or using the Format Paintbrush in the Standard toolbar.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
