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! ----- Original Message ---- From: Joe Conner <[EMAIL PROTECTED]> To: [email protected] 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 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] ____________________________________________________________________________________ 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]
