4 replies
by 5foot1 Accepted solution
by tobif Accepted solution
Have you tried forcing a recalculation? (I think it's F9)
Theory: Perhaps this sometimes happens if you have automatic recalculation disabled (reasonable for large amounts of data)
by oldbaritone Accepted solution
To toggle between formula view and result view, hit Ctrl-tilde (the squiggle line that looks sort-of like an S on its side)
that will change back and forth between (e.g.)
=2+2
and
4
by tobif Accepted solution
The following I tried in Excel 2003.
If a cell is formatted as "Text", then the format painter won't change that.
You need to change to a suitable number format instead.
Press Ctrl-1 (Ctrl and number "one") and select, say, "general" under the "Number" tab.
Please also note, that if a formula is treated as a text value, then the formula won't correctly change references when it is copied of moved around.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending