__/ [ John A. Bailo ] on Monday 15 January 2007 19:45 \__
>
> I am using OO Calc to make up a monthly budget.
>
> I formatted three columns, Item, Monthly Cost, Yearly Cost.
>
> So it would have something like:
>
> Rent $615 $7380
>
> The third column is a formula, of the value of the cell to the left of it
> times 12. I copied the formula down the column so I could add more items
> and it left a bunch of zeros since I had not yet entered anything in those
> rows.
>
> I remembered that Excel had a three part number format for values that are
> positive, negative or zero, they are a separated by semi-colons, something
> like:
>
> #;#;#
>
>
> I wondered if OO Calc used the same format, and lo and behold it does! I
> was able to format the cells with the number format:
>
> 0;0;#
>
> And it made the zeroes go away. Then, since I don't remember ever seeing
> that in anything other than Excel, I thought, I wonder if they patented
> that.
All the Myth about Microsoft!
^^^^
,----[ Quote ]
| * Microsoft was first with graphical user interface
|
| * Microsoft designed BASIC Language
|
| * Microsoft designed visual basic
|
| * Microsoft invented DOS
|
| * Microsoft designed the first spreadsheet - Excel
| ^^^^^^^^^^^^^^^^^^^^^^^^^ ??
|
| * Microsoft designed the first word processor
|
| * First with Internet browser
`----
http://196.2.70.231:8080/ict_blog/open-ict-hacks/microsoft-myth
--
~~ Best regards
Roy S. Schestowitz | HTML is for page layout, not for textual messages
http://Schestowitz.com | RHAT GNU/Linux ¦ PGP-Key: 0x74572E8E
8:00pm up 89 days 6:14, 7 users, load average: 0.60, 0.58, 0.70
http://iuron.com - help build a non-profit search engine
|
|
