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)).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]