incorect operators displayed

Question

incorect operators displayed

I have just started using Numbers (3.6.2 (2577)), having switched from MS Office, and I am a bit puzzled. My first obstacle is that Numbers seems to have a little bug that makes it display the operator / (division) as + (addition), whist it calculates correctly it is confusing when editing an equation. All other operators display correctly.

Also the EDIT function does not seem to display cell co-ordinates but just Header labels. This could be my ignorance but I can find no other way of displaying an equation than to use the formula edit function.

Am I alone in having these problems?

iMac, OS X El Capitan (10.11.4), i5 2.8Ghz Quad core, 16Gb Ram

Posted on Jun 5, 2016 4:36 AM

Reply

Answer 1

Yellowbox

Level 7

21,945 points

Jun 5, 2016 5:59 AM in response to Andrew Turnham

Hi Andrew,

Am I alone in having these problems?

You are not alone 😉.

a little bug that makes it display the operator / (division) as + (addition)

Numbers 3 changes / to the division sign ÷

At the default font size, that looks like a plus sign. Many (including me) have been caught out.

the EDIT function does not seem to display cell co-ordinates but just Header labels

Menu > Numbers > Preferences >

Turn off (untick) Use header names as labels.

Regards,

Ian.

Reply

Answer 2

Jun 5, 2016 6:15 AM in response to Yellowbox

Many thanks, I'm happy now and can go on exploring Numbers with a smile on my face.

Reply

Answer 3

Yellowbox

Level 7

21,945 points

Jun 5, 2016 6:20 AM in response to Andrew Turnham

Hi Andrew,

Glad to help and thanks for the green tick and your feedback. Please call back with other questions.

Happy Numbering 🙂.

Regards,

Ian.

Reply