Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Faint highlighting when editing formula, any ideas??

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?

Posted on Oct 4, 2019 9:54 AM

Reply
Question marked as Best answer

Hi 1234x,


Check to see if they are formatted as number values. SUM would ignore text values.


quinn

Posted on Oct 4, 2019 10:13 AM

1 reply
3 replies

Faint highlighting when editing formula, any ideas??

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.