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.)
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?
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
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.
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.
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!
@@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.
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.
Hi Gary love your videos Just started following you on how to use Numbers, I have a spread sheet and cannot figure out how to make the date in a column increase for the whole month 12-1-24 to 12-30-24
Sorry, I don't know what you mean by "how to make the date in a column increase for the whole month." Do you mean you want to change the column width? Or add more rows? I'm missing something in your description.
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?
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.
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.
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?
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.
Thank you again and again, Gary!
No idea that Numbers had such extensive formatting options. Thanks!
Your first example helped me solve a problem I've been trying to work out for some time now. Thank you. Great video.
Another excellent tour of useful features!
blown away...thanks Gary...you're awesome...
I hav watched this video three times and it always describes something new.
Great video Gary! Thanks for all those helpful video's!
Definitely want to create a new project to use all these tricks you've presented! Thanks for teaching!!
bonjour Gary, as always very impressive, a pleasure to discover Numbers features ...
your "numbers" movies is great. thank you. I learn a lot.
Thank you, very helpful! 👍🏻
Very informative video tutorial today! Thank you, Gary! 👍🏻❤️
Very good job! Thanx
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😊
Thank you and thanks for helping me with Word yesterday.
Great info. Thanks!
Excellent thanks
Very good.
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.
Most of them should. But you'd have to get familiar with the buttons and menus on the iPad first, so you know where to look to find things.
@@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.)
@@davidolden971 Have you tried a keyboard for your iPad?
@@joestechbits6261 Yes, I have for a while. I use an Apple Bluetooth Keyboard (the kind that takes 2 AA batteries, and I love it).
2:18 You have shown how to add meters but what format do we need to enter for values
Add a rule. Click the "Add a Rule" button and then set it to if the value is 1, display "meter" or whatever you want to use.
Thanks. I have always wanted the date to look just how I wanted. I now have my perfect date.
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?
Notes doesn't have that functionality.
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
Copy that cell. Then use Edit, Paste Formula Results to overwrite it with the fixed value.
Gary says thanks for watching, I say no thank you Gary👍
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.
thank you Garry!Switzerland..settingsRegion are ok but no apostrophedoesnot appear. I tried to format without success. @@macmost
i contacted apple support. it was a bug they find a way. thankyou Garry
@@macmost Exacty. but i've to putlanguages english (principaly and my region lang
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.
The formula you use, powers and multiplying, to get a Hex value; is that a standard formula? Is there a particular reason to use powers 8/16 etc?
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.
How can we add a popup calendar to pick the date in Numbers? Thanks
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 th-cam.com/video/x4PZbRp_K3k/w-d-xo.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.
@@jakeman1968 Yeah, I don't think there is a way to do that. $0.1049 is your best bet.
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.
How do you format for email addresses in a column?
Email addresses are just text. They aren't number values. So not sure what you are trying to do.
Hi Gary love your videos Just started following you on how to use Numbers, I have a spread sheet and cannot figure out how to make the date in a column increase for the whole month 12-1-24 to 12-30-24
Sorry, I don't know what you mean by "how to make the date in a column increase for the whole month." Do you mean you want to change the column width? Or add more rows? I'm missing something in your description.
@@macmost sorry I figured it out thanks
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?
Copy and paste.
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.
So simple when you know how
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.
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
Why click check after the first two parts? Just enter in the entire IP address (all 4 parts).
@@macmost ive tried every custom format I could think of, nothing work. Ive tried: "###.###.##.###" "###" "#.#.#.#" nothing works
@@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
Hard to know what you are trying to do without an example.
@@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.
@@sandiereedjewelry You need a lookup table. macmost.com/a-simple-numbers-lookup-example.html
2 few Os in TO! ;)
pour la formation des nombres + ou -
If you use proper English , saying the value is TOO High, does that effect the formula or conditional cell? thank you
Not sure what you are asking there. Where, exactly, would you be using the word "too?"
I’m back to using Numbers and dumping ‘the other one’
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.
Even to cut and paste has problems! the word 'too' was omitted. Too is the adverb!
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?
@@macmost… at around 5 mins, typing “TO LOW”, “TO HIGH”.
Oh! You’re right! That should be too. At least it isn’t as bad as using two, which would have been unforgivable.
@@macmost I wouldn’t worry two much, these things happen too the best of people, especially on Twosdays.