What a brilliant idea! You know for a lot less trouble, I could just stick a piece of tape down the montior to cover up those cents!!!!! :-)
----- Original Message ---- From: kevin johnston <[EMAIL PROTECTED]> To: [email protected] Sent: Saturday, December 1, 2007 12:08:02 AM Subject: Re: [users] Calc: Format/Formula help The fundamental restriction is that a cell in a spreadsheet can contain a value or it can contain a formula. A single cell cannot contain both a value and a formula using that value to construct a *different* value for display. But I have an idea. I don't claim it's pretty, and I won't be offended if you recoil in disgust. But it accomplishes *strictly* what you requested: Specifically, column A contains the exact dollars and cents value, without displaying the cents. Let's assume for the moment that numeric values are right-justified. (This is the default for numeric values.) Let's *also* assume that you *always* enter a decimal and two cents digits, even for round dollar values. You could enter all your numbers in column A, and cover the right hand margin of column A with a white rectangle that just happens 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. :) Jonathan Knight wrote: > 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] ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
