You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello, it seems that some numbers, maybe ones that were copy and pasted from another source document are highlighted faintly when editing the SUM formula and are throwing off the final calculation. Any ideas?
Hi 1234x,
Check to see if they are formatted as number values. SUM would ignore text values.
quinn
Hi 1234x,
Check to see if they are formatted as number values. SUM would ignore text values.
quinn
One thing you could try is command-c to copy and then, in another range of cells, Edit > Paste and Match Style.
SG
it seemed to have something to do with the formatting. Thanks
Faint highlighting when editing formula, any ideas??
