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 dollar amount entered?
<<SNIP>>
The obvious first solution is to move to using columns B and C for the
whole number and fraction with the raw value in column A.
Then in column B you can have =(A1 - C1). and in column C you can have
=IF(ISBLANK(A1);"";100*MOD(A1;1)).
On second thought, it may be safer to use in column B "
=IF(ISBLANK(A1);"";TRUNC(A1;0)) " and in column C use " =IF(ISBLANK(A1)
; "" ; A1-A2) ".
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]