Multiplying cell values
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 |
Multiplying cell values
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 |
Multiplying cell values
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 |
All times are GMT +1. The time now is 08:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com