3
votes
1answer
249 views

Numbers: conditonal highlight based on a date in a different column

In numbers, I would like to change the background colour of Column D based on whether the date in Column A is still in the future (i.e. graying out). I can get the colour formatting to work on the ...
0
votes
0answers
37 views

How to maintain capital letters within a Numbers files exported as a CSV file?

I imported a CSV file into Numbers which contained emails, phone #'s, first and last names. I cleaned up the data in Numbers so that names started with capital letters and phone numbers contained ...
1
vote
0answers
273 views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
1
vote
1answer
573 views

How to set default number formatting in Numbers?

In Numbers, I've seen how to change the default cell colour and font, based on table styles. But how can one change the default number formatting? The default "American" formatting for dates, for ...
2
votes
1answer
449 views

Is it possible to change text size & formatting of Numbers' formula input field?

Is it possible to set the text-size and possibly other formatting of the actual values/formula input field in Apple iWork Numbers? Comparing these two screenshots, it seems possible to set the size ...
2
votes
1answer
539 views

How to setup Indian rupee format in Numbers?

Indian rupee number format is different from US number format. e.g. 1,00,00,00,000 http://en.wikipedia.org/wiki/Indian_rupee How do I setup a custom number format in Numbers?
1
vote
1answer
307 views

In Numbers, how can I determine the default formatting of cells in rows that have just been added to a sheet?

When using Numbers, I have noticed that whenever I add a new row above existing rows, all of the formatting for the new row is exactly like the rows below it. However, if I add a new row below ...