Dear Brian,
Thanks a lot for the tip. It's not perfect like this but it is OK.
Another question concerns a table like the one shown here
Is ist possible to get in Calc a dashed line to separate several lines from
each other when they belong to the same group for instance?
Regards
Guido PAUELS
----- Original Message -----
From: "Brian Barker" <[EMAIL PROTECTED]>
To: <[email protected]>
Cc: "Guido PAUELS" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2007 2:45 AM
Subject: Re: [users] default number format
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]
