Multiplying cell values

[Guest]

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

 

[Jan Karel Pieterse]

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

 

[Roger Govier]

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 cells>Paste Special>Divide.