HIDING DATA IN A CELL

R

REDSHARK

I WANT TO KNOW HOW TO HIDE DATA IN A PARTICULAR CELL. I'M ROUNDING UP A SUM THAT HAS SEVERAL DIGITS, AND I DON'T WANT THE LONGER # TO APPEAR IN A CELL...JUST THE ROUNDED # THAT APPEARS IN THE ADJOINING CELL. NOT TOO CONFUSING RIGHT?
 
P

Peter Atherton

-----Original Message-----
I WANT TO KNOW HOW TO HIDE DATA IN A PARTICULAR CELL. I'M
Click to expand...
ROUNDING UP A SUM THAT HAS SEVERAL DIGITS, AND I DON'T
WANT THE LONGER # TO APPEAR IN A CELL...JUST THE ROUNDED #
THAT APPEARS IN THE ADJOINING CELL. NOT TOO CONFUSING
RIGHT?
.
Click to expand...
Why not just round the sum? e.g =ROUND(SUM(H6:H7),0)
rounds to a whole number
or
You could just format the cell to show no decimal places.

Peter Atherton
 
E

Earl Kiosterud

Red,

First, turn off your caps lock.

=ROUND(SUM(whatever,0)
to do it all in one cell
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

REDSHARK said:
I WANT TO KNOW HOW TO HIDE DATA IN A PARTICULAR CELL. I'M ROUNDING UP A
Click to expand...
SUM THAT HAS SEVERAL DIGITS, AND I DON'T WANT THE LONGER # TO APPEAR IN A
CELL...JUST THE ROUNDED # THAT APPEARS IN THE ADJOINING CELL. NOT TOO
CONFUSING RIGHT?
 
R

routeram

Hi,

If you want to hide the contents totally,

Right click on cell ... format cells......number tab......custo
format.... and type ";;;" (without quotes ) in the Type textbox...
Click Ok.

Regards,
Ra
 
R

REDSHARK

THANKS...LEARN SOMETHING NEW EVERY DAY

Peter Atherton said:
ROUNDING UP A SUM THAT HAS SEVERAL DIGITS, AND I DON'T
WANT THE LONGER # TO APPEAR IN A CELL...JUST THE ROUNDED #
THAT APPEARS IN THE ADJOINING CELL. NOT TOO CONFUSING
RIGHT?
Why not just round the sum? e.g =ROUND(SUM(H6:H7),0)
rounds to a whole number
or
You could just format the cell to show no decimal places.

Peter Atherton
Click to expand...
 
Top