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, then just display the cents in
B & the whole dollars in A. Here's the formula I'm using so far in Column B
"=IF(ISBLANK(A1);"";100*MOD(A1;1))"
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?
Many thanks,
Jon Knight
____________________________________________________________________________________
Be a better sports nut! Let your teams follow you
with Yahoo Mobile. Try it now.
http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
