How do I show only the whole number w/o eliminating four decim
It works, but is there a way to do this in the same cell?
"Bill Kuunders" wrote:
One way
number is in A1
enter in B1
=INT(A1)
Greetings from New Zealand
"Dave F" wrote in message
...
The formatting toolbar has a button that allows you to decrease the number
of
decimals. It looks like an arrow pointing to the right with a bunch of
zeroes on it...
Dave
--
Brevity is the soul of wit.
"kell~0" wrote:
I need to show only the whole number, not the number resulting by
removing
the decimals. We do not want to force all of these cells.
So, if the number is $104,978.6849 it needs to show $104,978, not
$104,979
How do I do this?
|