How do I display the formulas?

Question

Level 1

2 points

How do I display the formulas?

I hope that Apple didn't forget to include this important feature!

Does anyone know how we can display the formulas in cells? In Excel there is a preference that you can turn on to display formulas.

In school work it is important to be able to show, on a print out/pdf, that formulas have been entered correctly. I can't find it anywhere or in the help file.

Thanks for your help.

Andrew

MacPro 2.66, Mac OS X (10.4.10), 9Gb RAM Dual Dell 24" QuickCam Fusion

Posted on Aug 14, 2007 1:45 AM

Reply

Answer 1

Maffster

Level 1

4 points

Aug 14, 2007 3:58 AM in response to educateer

Unfortunately Apple do appear to have forgotten this important feature.

You'd have thought a very simple beta test of this program with anybody in the education sector would have picked this up straight way.

Education is an important market for Apple, this is something that is going to put Numbers straight into the reject pile for most schools.
Our choice remains to stick with outdated Appleworks or use Excel.

Reply

Answer 2

KOENIG Yvan

Level 8

41,819 points

Aug 25, 2007 2:36 AM in response to Maffster

Hello

The needed feature is available but "hidden".

Select the range of cells containing the formulas.
Apply the format "Text" and you will see every formulas.

Yvan KOENIG (from FRANCE samedi 25 août 2007 11:36:21)

Reply

Answer 3

educateer Author

Level 1

2 points

Aug 25, 2007 8:07 AM in response to KOENIG Yvan

Yvan, thank you for finding the solution.

I was scratching my head over this one and I am so happy that we can display formulas. It looks like the students should be able to use Numbers for their coursework after all.

I was hoping that they would because I think it is a really neat spreadsheet package and takes me back to the simplicity that we used to have by adding a spreadsheet to an old appleworks drawing document.

I love the extra things though like the drag and drop commonly used formulas.

Reply

Answer 4

Sep 4, 2007 5:26 PM in response to educateer

Another way to display formulas is by placing an apostrophe in front of the formula.

Details here:

http://www.numberstemplates.com/2007/09/04/tips-how-to-show-formulas-in-apple-iw ork-numbers/

Reply

Answer 5

WWJD

Level 6

15,830 points

Aug 25, 2007 8:18 AM in response to educateer

One can copy the sheet then do the formatting as noted above on the copy.

Regards,

Reply