tinkythomas
Active Member
- Joined
- Dec 13, 2006
- Messages
- 432
Hi,
I have a workbook with several worksheets and considerable number of formulas, one worksheet has over 30,000 rows.
The problem is the formula isn't returning a value but the formula itself. Now I know this is due to data types, I can format the cell as general then hit F2, enter and the value is returned.
The problem is if I copy the formula down the result from the first cell is copied to all cells. I understandably don't want to format, F2 and enter on every cell!
Thanks
I have a workbook with several worksheets and considerable number of formulas, one worksheet has over 30,000 rows.
The problem is the formula isn't returning a value but the formula itself. Now I know this is due to data types, I can format the cell as general then hit F2, enter and the value is returned.
The problem is if I copy the formula down the result from the first cell is copied to all cells. I understandably don't want to format, F2 and enter on every cell!
Thanks