060109 Iain Buchanan wrote:
> you may know that M$Excel has a number format called "accounting" IIRC,
> that lines up the currency sign:
> $ 10.00
> $ 100.00
> $ 1000.00
> $ -123.45
> Openoffice, as far as I've know it from 1.x to the current 2.x
> doesn't have such an option. The formatting comes out like this:
> $ 10.00
> $ 100.00
> $ 1000.00
> $ -123.45
>
> For a large spreadsheet, with lots of number,
> the aligned "$" is much easier to read.
I realise this is not what you are looking for
& also may not meet professional accounting rules for layout,
but a very simple & elegant solution is simply
to write the currency symbol (or any other units)
in a row on its own near the top of the sheet:
$ % riders/year
10.00 23.6 170 000
100.00 54.7 265 500
1000.00 67.8 143 200
I find it much easier to read tables with varied units this way
& always use it when writing tables myself.
HTH if no-one can suggest anything closer to your request.
--
========================,,============================================
SUPPORT ___________//___, Philip Webb : [EMAIL PROTECTED]
ELECTRIC /] [] [] [] [] []| Centre for Urban & Community Studies
TRANSIT `-O----------O---' University of Toronto
--
[email protected] mailing list
