Jonathan Knight wrote:
All,
I've got a typical accounting use for a spreadsheet. Basically mimicing a
columnar pad.
Column A Column B contain the dollars cents respectively.vvMy current
solution requires me to enter the whole dollars into A, the whole cents into B.
I would like to enter
In article [EMAIL PROTECTED], Jo [EMAIL PROTECTED] wrote:
Jonathan Knight wrote:
All, I've got a typical accounting use for a spreadsheet. Basically
mimicing a columnar pad.
Column A Column B contain the dollars cents respectively.vvMy
current solution requires me to enter the whole
On 01/12/2007 15:18, Troll/Idiot wrote:
Jonathan Knight wrote:
What a brilliant idea! You know for a lot less trouble, I could just
stick a piece of tape down the montior to cover up those cents!
:-)
I've tried it. The tape doesn't stick very well to the white-out.
: [users] Calc: Format/Formula help
The fundamental restriction is that a cell in a spreadsheet can contain
a value or it can contain a formula. A single cell cannot contain both a
value and a formula using that value to construct a *different* value
for display.
But I have an idea. I don't claim
Jonathan Knight wrote:
What a brilliant idea! You know for a lot less trouble, I could just stick a
piece of tape down the montior to cover up those cents! :-)
I've tried it. The tape doesn't stick very well to the white-out.
, December 1, 2007 12:08:02 AM
Subject: Re: [users] Calc: Format/Formula help
The fundamental restriction is that a cell in a spreadsheet can contain
a value or it can contain a formula. A single cell cannot contain both a
value and a formula using that value to construct a *different* value
Jonathan Knight wrote:
That's what I was trying to avoid. Was hoping there is a formatting solution
for the whole dollars. I don't want to move the value to another cell since
it's a standard form we use.
Anyway, thanks for the input!
Why not then use a different worksheet for the input,
@openoffice.org
Sent: Friday, November 30, 2007 2:04:03 PM
Subject: Re: [users] Calc: Format/Formula help
Jonathan Knight wrote:
SNIP
That part works great! Only problem is I still see the cents in Column A. I
tried to change the format to zero decimal places, but it rounds the value!
Not what I
All,
I've got a typical accounting use for a spreadsheet. Basically mimicing a
columnar pad.
Column A Column B contain the dollars cents respectively.vvMy current
solution requires me to enter the whole dollars into A, the whole cents into B.
I would like to enter the entire amount into A,
:03 PM
Subject: Re: [users] Calc: Format/Formula help
Jonathan Knight wrote:
SNIP
That part works great! Only problem is I still see the cents in Column A. I
tried to change the
format to zero decimal places, but it rounds the value! Not what I
want. Anyone have any ideas for formatting
: Joe Conner [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Friday, November 30, 2007 3:16:10 PM
Subject: Re: [users] Calc: Format/Formula help
Jonathan Knight wrote:
That's what I was trying to avoid. Was hoping there is a formatting solution
for the whole dollars. I don't want to move
Jonathan Knight wrote:
SNIP
That part works great! Only problem is I still see the cents in Column A. I
tried to change the format to zero decimal places, but it rounds the value!
Not what I want. Anyone have any ideas for formatting Column A to just show
the whole dollar amount entered?
Joe Conner wrote:
Jonathan Knight wrote:
SNIP
That part works great! Only problem is I still see the cents in
Column A. I tried to change the format to zero decimal places, but
it rounds the value! Not what I want. Anyone have any ideas for
formatting Column A to just show the whole
13 matches
Mail list logo