
Chapter 4: Spreadsheets in Calc
3. In the Search for box, enter ^[0-9]
4. In the Replace with box enter: &
5. Check Regular expressions
6. Check Current selection only
7. Click Replace All
Cells in the Currency Format
In Calc numbers can have any currency format. Clicking the Currency icon in
the object list formats the number and the cell is given the default currency
format as set in OpenOffice.org under Tools > Options - Language Settings
> Languages.
Without currency formats, the international exchange of Calc documents could lead to
misunderstandings. For example, an Calc document is loaded by a user who uses a different
default currency format.
OpenOffice.org User Guide for 2.x 215
Kommentare zu diesen Handbüchern