Excel 3D Map of the UK
0:17
10 ай бұрын
Dieting with Excel Pivot Tables
4:44
The 1-Hour Website
24:02
Жыл бұрын
Under Construction
0:16
Жыл бұрын
How to Create a Budget in Excel
6:12
Mail Merge in 6 Steps
11:48
Жыл бұрын
Easy Absolute References
8:09
Жыл бұрын
Playing with Pivot Tables
22:42
2 жыл бұрын
Fun with Formulas
19:32
2 жыл бұрын
4 Rules for Formulas
10:02
2 жыл бұрын
3 Ways to Format Mail Merge Numbers
14:34
Пікірлер
@paularnold-b8h
@paularnold-b8h Күн бұрын
Awesome!! Thanks!! My problem solved☺️
@levibrecke337
@levibrecke337 4 күн бұрын
Excellent series of videos and demonstrations, thank you.
@CHENHAREL52
@CHENHAREL52 12 күн бұрын
Huge thanks! It saved me so much time. Excellent video and explains in a simple way, thank you!!
@giftynyahe6880
@giftynyahe6880 Ай бұрын
Great tutorial
@BridgetteLemon-v8u
@BridgetteLemon-v8u Ай бұрын
Very thorough and helpful - thank you :)
@user-ok7rg8bl2e
@user-ok7rg8bl2e Ай бұрын
Standing Ovation over here. Thank you thank you thank you.....
@jjuukowilliamgeorge679
@jjuukowilliamgeorge679 Ай бұрын
I just like this old man"Rich" keep it up
@Izaanshakkir
@Izaanshakkir Ай бұрын
I was now fully clear with mail merge thanks for your help☺
@KlutseHilda
@KlutseHilda Ай бұрын
This is really simple. Thank you for the tutorial
@MungunguAnnely-eh6ue
@MungunguAnnely-eh6ue 2 ай бұрын
❤❤❤❤❤ CT
@milenadoncev
@milenadoncev 3 ай бұрын
Tnx a lot!
@priyalemon1944
@priyalemon1944 3 ай бұрын
I watched a lot of videos on Mail Merge and this one is definitely the best and easiest to follow. Thank you.
@techhelptoday274
@techhelptoday274 3 ай бұрын
Thank you so much for the kind words. Glad it was helpful!
@LucretiaVanPelt
@LucretiaVanPelt 4 ай бұрын
Thank you, kindly!
@techhelptoday274
@techhelptoday274 4 ай бұрын
You're very welcome!
@siraries1319
@siraries1319 4 ай бұрын
Custom Animations and Timing in Microsoft Powerpoint Presentation - Empowerment Technology - Grade11 kzfaq.info/get/bejne/jrRjeKt6r6-0aHk.html Mail Merge Custom Animations and Timing in Microsoft Word - Empowerment Technology - Grade11 kzfaq.info/get/bejne/jrRjeKt6r6-0aHk.html
@hezbonongeri-qe1jj
@hezbonongeri-qe1jj 4 ай бұрын
this was good Mr.
@user-dp6vr3yx2y
@user-dp6vr3yx2y 5 ай бұрын
thanks teacher
@user-ny2tv2uq4c
@user-ny2tv2uq4c 5 ай бұрын
So helpful! And it works! Thank you.
@techhelptoday274
@techhelptoday274 4 ай бұрын
Great to hear!
@judithroom3656
@judithroom3656 5 ай бұрын
Hi are you able to add in the mail merge code for a date that is in the UK format eg day/ month/ year not month/ day/ year? Thank you
@kanishkap3326
@kanishkap3326 5 ай бұрын
Thank you this video helped me a lot
@user-vj4bd9br3x
@user-vj4bd9br3x 6 ай бұрын
Thanks for the tutorial. A very simple step by step procedure. Easy to understand.
@user-lw1so1sw7w
@user-lw1so1sw7w 6 ай бұрын
Option 3 did NOT work for me. I will try and see if there's a Power Automate version of Microsoft Word print to do this in 365. When you do Power Automate for E-Mails it doesn't seem to have trouble transferring over the $amount. Gosh, this is difficult!!!!
@pashayevagunay6663
@pashayevagunay6663 8 ай бұрын
I need support. I need the number format as #.0,00 as per Italy and Netherlands regulations. The format is correct in excel but when I do mail merge it disappears. I need support
@brendachin6664
@brendachin6664 8 ай бұрын
Very helpful, well done
@user-ij5yn4jl2v
@user-ij5yn4jl2v 8 ай бұрын
I've just put a $ sign in front of the first bracket { and it worked. Then a % sign in front of the last bracket where I wanted a percentage figure, also worked.
@vasilisa6128
@vasilisa6128 9 ай бұрын
Thank you so much, Rich! In just 2.5 minutes you solved my problem that had been going on for many years! It helped! I couldn't fight this number format errors before, finally for a long time I saved it as text, but I haven't used TEXT function with format option! Thank you!
@techhelptoday274
@techhelptoday274 8 ай бұрын
Glad it helped! Thanks for your feedback.
@iolanisjourney4828
@iolanisjourney4828 9 ай бұрын
Most straightforward and helpful tutorial ever!!!! THANK YOU 😊
@techhelptoday274
@techhelptoday274 9 ай бұрын
Thank you for the kind words. I hope you found the information useful.
@vickylam5846
@vickylam5846 9 ай бұрын
I can find the excel file for mail merge above hyperlink provided? where is it? thanks
@vickylam5846
@vickylam5846 9 ай бұрын
sorry for my typo, I mean can't find the excel indeed.
@vickylam5846
@vickylam5846 9 ай бұрын
Thanks for your video which is very good indeed. 1 question is that should I define the Title, First name in the "more items" icon or in the Inseret Merge field where I can see same information available, what is the different? thanks. 👍👍
@audreytania8240
@audreytania8240 9 ай бұрын
Awesome!! Option no. 3 works for me. Thank you so much 🎉 ..and I subscribed! 😊
@bucknips
@bucknips 10 ай бұрын
Thank you, Thank you!!!! You are a very good teacher!
@user-np5vf4ei3e
@user-np5vf4ei3e 10 ай бұрын
This was the best help I found for currency and date, Thank you!
@amyluckenbill5515
@amyluckenbill5515 11 ай бұрын
Yes. Hands down, the best tutorial. Quick fix using picture switch. Thank you for the lesson!!
@mohammedziyad1381
@mohammedziyad1381 Жыл бұрын
Thank you for the nice lesson ❤
@ferryboma
@ferryboma Жыл бұрын
its easier to use codes, i think
@merbella4201
@merbella4201 Жыл бұрын
very helpful video - solved my issue with mail erge and figures with excesive numbers after the decimal point.
@BrianKasenLFP
@BrianKasenLFP Жыл бұрын
Your links don't work!
@techhelptoday274
@techhelptoday274 Жыл бұрын
Thank you for letting me know. There was a change in the website that mangled some links. All links work now. I appreciate the feedback. - Rich
@sharonannis103
@sharonannis103 Жыл бұрын
THANK YOU! You saved me so much time just be doing the excel TEXT function!!!!
@ClaudiaAgostinho
@ClaudiaAgostinho Жыл бұрын
In Office 365 only works the first option. In older versions I used the DDE and was easier
@shanhussain3202
@shanhussain3202 Жыл бұрын
Thank you very much and appreciated .
@techhelptoday274
@techhelptoday274 Жыл бұрын
You are very welcome!
@IvanIvanov-us7yu
@IvanIvanov-us7yu Жыл бұрын
Hello! Could you tell, please, how to display common fractions? For example, I have 0.5 in Excel and I need 1/2 in Word. Can't find information anywhere.
@azhjustinkanda7420
@azhjustinkanda7420 Жыл бұрын
Thank youuu this video helped me so muchhh
@techhelptoday274
@techhelptoday274 Жыл бұрын
Glad it helped!
@bilallechvien4558
@bilallechvien4558 Жыл бұрын
nice video
@techhelptoday274
@techhelptoday274 Жыл бұрын
Thank you. Glad you liked it.
@gregdubz3522
@gregdubz3522 Жыл бұрын
Thanks. but what if you are filling out a form where you need the comma for a large number but you also do NOT want the comma if the value is 0? Example: 1,000.00 and 0.00 in the same data set.
@techhelptoday274
@techhelptoday274 Жыл бұрын
If you use the code #,##0.00, the comma will only appear if you have four or more digits to the left of the decimal point.
@GLITCH15_17
@GLITCH15_17 Жыл бұрын
@@techhelptoday274 Hi there, am trying to use this formula in my Mail Merge Word doc: #,##0.00 however I need as separator not a "'," but a "." and then for decimals I need a "',". So basically instead of having 2,546.37 I need to have 2.546,37. Is this achievable?
@tubeguiller007
@tubeguiller007 Жыл бұрын
Thank you so much for this video...
@techhelptoday274
@techhelptoday274 Жыл бұрын
You are very welcome. Hope you found it useful.
@butterfly06830
@butterfly06830 Жыл бұрын
This is GREAT ! Thank you for sharing Help Tech... NP
@techhelptoday274
@techhelptoday274 Жыл бұрын
Glad you enjoyed it, Jasper. Thanks for the feedback.
@techhelptoday274
@techhelptoday274 Жыл бұрын
I found another nice trick that ChatGPT can do: I asked it to "summarize the following article" and then pasted in a 2,000-word article from the Wall Street Journal. ChatGPT then quickly gave me a nice 125-word summary. Yes, lots of details were missing, but it did a good job on the main points - and saved me some time! - Rich
@dmsarojani4173
@dmsarojani4173 Жыл бұрын
Thnkx its good
@techhelptoday274
@techhelptoday274 Жыл бұрын
You're very welcome!
@mirama765
@mirama765 Жыл бұрын
Good day! {MERGEFIELD TaxItem.TaxRate \# ##%} doesn't print the 0%. We see only the percentage sign, the ZERO desappears completely... 6%, 12% are printing without problem, but not ZERO%. Please help.
@techhelptoday274
@techhelptoday274 Жыл бұрын
Use the code: \# 0% Note that the # symbol will display all numerals except a leading zero. By contrast, the 0 symbol will display all numerals including a leading zero (or a following zero after the decimal point). For example the format code ##.## might display a number as 3.1 while 00.00 will display the same number as 03.10. I hope this helps.
@ornashuva
@ornashuva Жыл бұрын
very good and clear explanation.
@techhelptoday274
@techhelptoday274 Жыл бұрын
Glad you think so!
@Linda-we6en
@Linda-we6en Жыл бұрын
Thank you this really helps me.
@techhelptoday274
@techhelptoday274 Жыл бұрын
Glad it helped!