I have an area of cells that contain either numerical values or text.

I need to divide every numerical cells value with a certain constant, but i
don't know how it can be done fast.

I also need simple a way to select just the cells containing numerical
values out of the whole area that also contains the text filled cells.

Thanks,

Kalanen

Hi Kalanen,

I need to divide every numerical cells value with a certain constant, but i
don't know how it can be done fast.

Enter number in empty cell, copy, select target area, paste special, select
proper operation. Text is ignored.

I also need simple a way to select just the cells containing numerical
values out of the whole area that also contains the text filled cells.

F5 (Edit, goto or control-g), special, Values, tick proper box(es).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

Hi

In a blank cell enter your constant. Copy that cell.
Mark the complete range of data containing the values you wish to
divide, including all the text cellsPaste SpecialDivide.

--
Regards

Roger Govier


"Kalanen" wrote in message
...
I have an area of cells that contain either numerical values or text.

I need to divide every numerical cells value with a certain constant,
but i
don't know how it can be done fast.

I also need simple a way to select just the cells containing numerical
values out of the whole area that also contains the text filled cells.

Thanks,

Kalanen