-
All replies
-
Helpful answers
-
Sep 14, 2016 6:18 PM in response to Gavin.mcby Wayne Contello,Number cannot sum based on formatting. You could write an applescript to perform this task if you want and you would have to remember to cause the script to run.
Never mind... I missed the fact that you are using Numbers on iOS. I do not think you can run Applescript on Numbers for iOS.
Here is an alternate way. Place an underscore"_" in front of the value (or any other non-numeric character) to make the content of the cell a string rather than a number. In that case the numeric value will be zero:
you can even add conditional formatting to highlight red when the cell contains an underscore:


