Tag Info

New answers tagged

0

You can do this directly in Numbers. First, add two empty columns after the column with the data you want to split. If the first piece of data you want to split is in cell B2 and is separated by a space, then use this formula in the empty cell C2: =LEFT(B2, FIND(" ",B2)) If the data is separated by a comma, then replace " " with ",". In the empty cell D2, ...


0

Select the menu item "File > Print", then use the controls on the right to scale the content:


1

I'm using Numbers 3.5 on Yosemite. In this version I can click the tiny arrow on the row number (e.g.. 1-20) or the column letter (e.g.. A-P) and this yields a menu (hover the row number or column letter to see the small arrow). The choices "Hide row" and "Hide column" are in those respective menus. According to your description, it appears that these ...


0

Thanks very much for the emailing solution! It lead me to a quicker one. I noticed that the email file had the extension .xls added to it. All you need to do is add .xls to files that are giving the "can't be opened" message and they seem to work again.


0

Highlight the entire link. Then use Format/Remove link.


0

What exactly are you trying to accomplish? Are you testing for the presence of the Groceries category label before adding the amount into your calculation? Are Category and Amount named collections/ranges? The format for SUMIF is: SUMIF(collection_to_test, "test condition", optional_collection_of_values_to_sum) So assuming Category and Amount are named ...


0

So the Apple thread recommended changing the txt to csv. This didn't work, my file was already csv, properly formated etc. No, changing to txt did the trick. I'm finding it harder and harder to recommend switching from Microsoft to Apple. This sort thing just shouldn't be happening.



Top 50 recent answers are included