On Wed, 23 Sep 2009 17:32:15 -0400, you wrote:
thanks >There is a switch in Excel relevant to currency cell formats that mimics >many adding machines, automatically making the last two digits entered >the decimal places. Find it in OO. > >The downside is you must enter "00" for even dollars. For me entering >the decimal point with right ring finger is more easier, consistent and >precise. Even in finance there are numbers that should be entered in >more than two decimal places. > >JRL >Akron > >Stanton A Hershman wrote: >> in excel you can adjust the cell contents so that if you enter -5432 >> you end up with (54.32) in red as the final cell contents. Stanton ************************************************ "It came to me that every time I lose a dog they take a piece of my heart with them. And every new dog who comes into my life gives me with a piece of their heart. If I live long enough, all the components of my heart will be dog, and I will become as generous and loving as they are." Unknown ************************************************ "Until one has loved an animal, part of their soul remains unawakened." --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org