# Tagged Questions

**0**

votes

**1**answer

10 views

### Val2 function in iWork Numbers?

Is there equivalent Excel Val2() function in Numbers? I want to get value of a cell, which contains formula. What I need to get the result text from the cell.
The following is example data:
A B ...

**1**

vote

**0**answers

48 views

### Pull multiple rows of data from one place in spreadsheet to another based on a condion

I have an iWork Numbers (3.2 - 1861) sheet with a list of people with the following structure:
| Name | Age | Email | Condition |
| Bart | 12 | test@test.com | ...

**0**

votes

**1**answer

317 views

### Numbers is no longer shipped with OSX from Mountain Lion?

I heave heard that Mac OSX Snow Leopard shipped with Numbers, an app used to manipulate spreadsheets. But I can't find it inside my default Mac OSX Mountain Lion installation. Checking with App Store, ...

**1**

vote

**1**answer

127 views

### Not showing negative results in Numbers.app

How can I make iWork Numbers not show me negative results?
For example: The thing is that in A1 I have number 101 and I am doing -A1 from B1. B1 is empty (because I am waiting for the result) so in ...

**0**

votes

**1**answer

172 views

### My Numbers Spreadsheet does not show any data

My Numbers spreadsheet shows blank even though it has data in it.
What could be wrong?
Please see attached image.

**3**

votes

**2**answers

2k views

### Apple Numbers: keyboard shortcut for “smart fill”?

If I've got some sort of patterned data selected — say sequential numbers — I can click and drag the little circle in the bottom right corner of that selection to “smart fill”. For example:
Is ...

**7**

votes

**2**answers

14k views

### How to interchange a column and row in a table (Transpose) in iWork Numbers?

I want to transpose a table (interchange rows to columns and vice versa). How to do that in iWork Numbers.

**0**

votes

**1**answer

2k views

### Select each nth row in Numbers

I have an iWork Numbers spreadsheet with thousands of rows. How can I select every 5th row from that spreadsheet?
See also: Select each nth row in Excel