ens to be the
exact width of a decimal and two digits.
Now in column B you can use your MOD formula to display the hidden cents
digits.
If you ever tell anyone this was my suggestion, I will deny it. Mail
headers are *so* easy to forge. Next time, think carefully what you ask
for. :)
Jonatha
From: 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.
TECTED]>
To: users@openoffice.org
Sent: Friday, November 30, 2007 2:04:03 PM
Subject: Re: [users] Calc: Format/Formula help
Jonathan Knight wrote:
> <>
> That part works great! Only problem is I still see the cents in Column A. I
> tried to change the format to zero decimal plac
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,