The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Stuck on Silly Excel Issue
TheDrifter
Registered User regular
Registered User regular
Hey...
So here's the situation.
I have some formulas (SUMIFs). Those formulas reference a block of cells. The cells will be data being copied into Excel.
The issue is, the formulas arent registering the pasted data. If I click into one of the data cells and click enter, then the formula will register it. Re formating the pasted data will not resolve the issue. So far, only clicking in the cell and pressing enter so it re-processes it works.
It isn't practical to do that every time. Is there a way to (for a lack of better term) re-process all the cells at once?
So here's the situation.
I have some formulas (SUMIFs). Those formulas reference a block of cells. The cells will be data being copied into Excel.
The issue is, the formulas arent registering the pasted data. If I click into one of the data cells and click enter, then the formula will register it. Re formating the pasted data will not resolve the issue. So far, only clicking in the cell and pressing enter so it re-processes it works.
It isn't practical to do that every time. Is there a way to (for a lack of better term) re-process all the cells at once?
0
Posts
Its like Excel can't "see" the pasted data until I've manually clicked enter on it, like I'm typing it in fresh,
then your SUMIFS function works fine.
An easy way to fix this en masse is to enter 1 into a blank cell off to the side, copy it, and paste-special- multiply on all the values that you want to turn into numbers.
Steam: Elvenshae // PSN: Elvenshae // WotC: Elvenshae
Wilds of Aladrion: [https://forums.penny-arcade.com/discussion/comment/43159014/#Comment_43159014]Ellandryn[/url]