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