NotExcelMaster
New Member
- Joined
- Dec 12, 2005
- Messages
- 3
For my work I'm using reports which are displayed in Excell format in IE window. There is no export or save button, so what i have to do is copy and paste.
When i try to create some formulas for one of the columns(e.g. SUM()) i get zero. This is because for some reason I am unable to format cells. Even though I change column data to number instead of general, no changes are visible (for example i change to number with 2 decimal places)untill I click on a cell and press F2(edit). Only then formula starts to work. Those cells are not locked.
Any thoughts?
When i try to create some formulas for one of the columns(e.g. SUM()) i get zero. This is because for some reason I am unable to format cells. Even though I change column data to number instead of general, no changes are visible (for example i change to number with 2 decimal places)untill I click on a cell and press F2(edit). Only then formula starts to work. Those cells are not locked.
Any thoughts?