-
as seen on Super User
- Search for 'Super User'
I have trouble to paste a list of strings in the format of 'mm/dd/yy' into iWork-Numbers. For example, I have a list of strings(text in VIM):
04/01/10
04/03/10
04/13/10
I copy those strings and then paste into my iWork-Numbers worksheet. The result will be:
2004-01-10
2004-03-10
04/13/10
It…
>>> More
-
as seen on Super User
- Search for 'Super User'
I have trouble to paste a list of strings in the format of 'mm/dd/yy' into iWork-Numbers. For example:
04/01/10
04/03/10
04/13/10
The result will be:
2004-01-10
2004-03-10
04/13/10
It looks like that Numbers convert the mm into year, then month and last day. Is there any way to paste whatever…
>>> More
-
as seen on Super User
- Search for 'Super User'
I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the total sum.
Is this possible with Numbers?
>>> More
-
as seen on Super User
- Search for 'Super User'
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 C
? 0 what?
For example, in cell A1 I have a function like:
=Right(C1)
which is the end character…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am new to Mac Numbers. I would like to know if there is a way that one spreadsheet can reference the values from another spreadsheet.
>>> More
