Tag Info

New answers tagged

0

From the Cell tab of the sidebar you can select the number of decimal places or set it to "Auto". Pick whatever best suits your needs.


1

Took me a while, but I figured it out: The solution is to choose a scatter plot instead of a line chart. Select Insert -> Chart -> 2D Scatter Select the chart, then select Add Chart Data: Now simply select your entire table, including the x axis. Numbers will figure out the rest and automatically select your leftmost column as the x-axis. Finally, to ...


1

The great thing about numbers is they offer a great how-to guide. If you don't know how to do something then all you have to is start typing a formula and it will begin to auto populate, click on it and the functions sidebar will open with the function. it will give you examples, what the parameters are etc. That's just a tip, but your lucky I'm here: ...


1

This is a hack, but assuming that your document won't be damaged by undergoing some slight changes, here is what I would do. Logon to www.iCloud.com, and open Numbers. If it isn't there, go to beta.iCloud.com. Upload the new Numbers document to iCloud and then open the document in your browser. Select Download a Copy from the settings menu (as seen in the ...


0

New Answer: 1) Open the attachment: 2) Select the icon as if you were going to forward in mail: 3) I then received the option to mail, save in numbers etc. I just saved an excel file to numbers on my IPhone 6. No I am not a techno geek but a 65 year old ex CPM type Philip B.


0

Using Daniel's tips I've come up with this solution: Create an auxiliary column Add the formula: IF(NOT(ISBLANK(A1)),"x"," ") Copy formula to all rows. Overwrite original column with values from auxiliary column. This isn't an ideal solution as I need to apply it individually to around 20 different columns. If anyone knows a way to do this without using ...


0

Here are a few hints: use an auxiliary column; use functions ISBLANK and IF; replicate the auxiliary column within the original one; remove the auxiliary column.


0

I had the same sort of problem and with some help from people within the Apple Support community I came up with this solution. Hopefully it will work for you. This is my list of players in sheet 1. In your case, the Players name would be the item codes. Here is sheet where I want to information copied to. The P# corresponds to the number next to the ...


0

this is how I solved it: tell application "iTunes" repeat with theTrack in selection set theFile to location of theTrack tell application "Finder" to set theName to name of theFile set ayahInSurahCount to 0 --set ayah information from the name of the track set surahNumAsString to characters 1 thru 3 of ...



Top 50 recent answers are included