This video, like most of your videos, deserve more views. To be honest I've only ever used Numbers in a very minimal way but now I'm retired and have some time I'm wondering why I never found the time to delve deeper before. Excellent presentation.
Same here. I used Words for everything (now Pages). I never bother to learn to use Numbers/Excel ‘effectively’. Gary’s videos made everything easy and I regretted not to use this app before.
All I can say is, the amount of information you have given to alter cell information and how it is presented is ,although some people may say this is basic, I’ve been using numbers for years, but if you don’t understand how to do something, or more importantly there is a easier/ shorter way of doing it. I have leaned something new, which isn’t that what it’s all about? Please keep on presenting more videos, numbers or the general Apple software or various device’s they produce, very productive vidio😊
Gary, I’m really enjoying these short tutorials. Until I can afford to replace my broken MacBook Pro, I’m currently limited to 2 devices: my iPhone X, and my iPad 9.7” (6th Generation). They’re each on 15.2.1 of their respective OS’s. How many of your Numbers tutorials work with iPadOS? (since that is my primary device). It was with this tutorial that I couldn’t apply the lesson on my iPad.
@@macmost Thanks for answering, Gary. I guess I’ll have to wait to use cell formatting on a future MacBook. (Again: really enjoying all your tutorials. I’m glad I subscribed.)
Hi Gary, thanks for the info and videos, very helpful. I am using a table to track stocks, but after calculating the stock price x current number of stocks, can I lock that number into that cell so when I buy more shares next month it will not change the value from the month before since the number of stocks changed. Thanks
Gary, do you have a video that shows you how to add an Apple Macbook Spread sheet into Apple Notes that will show updates if I make changes to the MacBook Number Spread sheet?
Great Garry, Now how can we save a format forever in numbers so it will work in any new spreadsheet file. I use phone numbers a lot but I have t recreate the number format everytime I start a new file. Can you help with that??? Thanks, Dan
Create a template with the styles you want. Then choose that template when you start a new document. You can also set a template to be used by default in Settings, General.
Any custom format I create seems to be restricted to the current spreadsheet. Is there a way to make any of my custom creations universal or accessible to other worksheets? If I can't do this, then I would have to re-created the wheel for every new spreadsheet I create.
Yes, it is for the document you are working on. If you want to use the same formats elsewhere, you can copy and paste. Or, create a template that has those formats in it. Or, start a new document by duplicating an old one.
Yes, that's a function built into Numbers. Colors are usually stated in hexadecimal (base 16) so instead of 255,255,0 you would see FFFF00. That's why I am using it here.
thank you Garry I don't findhow to format to replace the comma in the thousands separator with an apostrophe. I can't find this information anywhere. Any idea?
Interesting. I'm curious about what language or region uses an apostrophe for a thousands separator. I've only heard of using a comma or sometimes a period as an alternative. Usually you would set this in System Settings, General, Language and Region. Then set your language and your region appropriately. Then check the Number Format field for that option. You can do it in Numbers by using Custom Format this way: Add the #,### type to the format. Then select it and set the number of digits to 3 instead of 4. Also set it to Hide Separator. Then put your thousands separator after it. Then add #,### again and set it to 3 again, Hide Separator again. So it would look like: ### ' ### That worked when I tested it.
Gary, I'm sure I've seen this in one of your other videos but can't seem to find it. I want to have the cell show 10.49¢ and still be able to use it as a currency. Help!
So instead of $10.49 you want it to show 10.49¢? You will probably need to create a custom format. See ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-x4PZbRp_K3k.html
@@macmost I don't want it to show $0.1049 and I can't get it to to do that with the custom format, unless I'm missing something. I want to be able to enter 10.49, it will show 10.49¢ but under the hood I know it's is 0.1049 so it uses the 0.1049 to multiply it with other columns. If it could work like how percentage works I'd be set but can't get custom format to do that.
How do you combine different spreadsheet data quickly? for example, how to combine monthly transactions data that is a separate numbers file for each month?
Almost perfect. Except you didn't show how to custom setup price changes high n low . In particular using an invoice and recording prices each week/delivery. How do I show whether the price was increased or decreased and what that values is in a column that follows. And is there a way to record each change/invoices prices over the period of a quarter/ year? Thanks.
Lot of questions. Each one is just a matter of figuring out the steps to do it. No easy way for me to answer here in a comment. You have to work at it.
Tge reason you don’t have more views is that we are all forced to use google (in Canadian education, at least). We must all name our children Google 1,2,3. Your videos are excellent.
I watched the entire video but still im stuck. Im trying to find a way to correctly format a field for IP addresses. I do number field without decimels, the a . and that 4 times to create the custom format. But after I fillout my first two adresses and check, it changed the format to automatic and I cant drag down to add plus one in the last set of numbers. Anybody have a solution for this? not sure what Im doing wrong
@@spawn666reaper I don't understand. If I select a blank cell in Numbers and type "123.456.789.000" I get the text "123.456.789.000" in that cell. What do you get?
Trying to add value to text instead of text to values which seems to be the opposite of what you are showing. I am sure there is a formula somewhere but can not find it
@@macmost I am trying to create a spreadsheet where I can calculate materials cost. I use a variety of gauged wires (16ga., 18ga., 20ga., etc.) each cost also varies. I am trying to create a column that would have a drop down box where if I enter 16ga. it would show and calculate .50 for that item ( or if the item was an 18ga. it would show .60, and such for each ga.) Therefore allowing me to add another column where I could add a formula to multiply the .50 x the amount of material used. I hope this makes sense. I appreciate your videos and your response.
My somewhat useless comment to an otherwise great video: "To is a preposition with several meanings, including “toward” and “until.” is an adverb that can mean “excessively” or “also.” Just to be clear: two is pronounced the same as to and , but it can't be used instead of either of them because it's a number.
Sorry, I don't understand the comment. Where am I using to/too/two incorrectly? With a masters in journalism, I certainly know the difference. As I'm speaking in a video here, not writing, how you can even know which one I'm using?