Very thorough and helpful - thank you :)

Tried several techniques, but hands down this is the best one which had explained properly and clearly!

I just like this old man"Rich" keep it up

Yes. Hands down, the best tutorial. Quick fix using picture switch. Thank you for the lesson!!

works one day and not the next. Love your instruction style! Thank you!

Thank you, Thank you!!!! You are a very good teacher!

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!

This was the best help I found for currency and date, Thank you!

THANK YOU! You saved me so much time just be doing the excel TEXT function!!!!

THANK YOU! I've used the DDE method for years and now it stopped working. Your video was a life saver.

I have never seen such a nice presentation before! Great!

Awesome!! Option no. 3 works for me. Thank you so much 🎉 ..and I subscribed! 😊

very helpful video - solved my issue with mail erge and figures with excesive numbers after the decimal point.

Very helpful, well done

Thank you so much. Second option of converting to text functions worked for me.

A great presentation, easy to understand, and very helpful. One thing missing which would be more useful for me would be to add percentages.

So helpful! And it works! Thank you.

Thanks for the video. I think it's incredible that we need to deal with such things in 2022. As usual, big thanks go to Microsoft for requiring a time-consuming workaround in each and every feature we touch...

Post Decimal solutions is unique... Thank you so much

Fantastic sir, it was easily understood and easily done. Thank you so much sir.

Thankyou very much for the clear explanation..... I have used it into my work ......it is very helpful ..... Hope for your more vedios....Godbless...🙂

Thank you very much, Sir.. This is so helpful!

That was helpful! Thank you.

Thank you! i loved the content.

Such a nice presentation. Thankyou

Thanks. This was very helpful.

Thanks. Very useful. Solved my problem

Tnx a lot!

Thank you so much your video saved my report!

Sir, Thank you so much. Superb and Unique Teaching.

very good and clear explanation.

Thank you very much and appreciated .

Thank you, kindly!

DDE Worked !!!! Thank you!

Thank you Sir. help a lot

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

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.

Awesome tip...

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

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!!!!

Useful information

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.

Thank you. Question: When we merge into outlook does merge at once all the letters together, or it separates in single letter for each email automatically? does it merge into the outbox and then later we decide to e-mail, or it delivers the email right away after merging. I ask because I am afraid to e-mail wrong letter or to wrong person, who knows, it would be ideal when merging, should go to outbox or to a special box, and to be reviewed and then we email.

Hi, I am facing error in word output. My alphanumeric value viz. MTX3852 is displayed as ZERO in word. Please help to get it fixed. Thanks in advance.

nice video

Thank you so much. Second option of converting to text functions worked But the Unicode language file does not work. Please reply

Hi how to use ordinals from excel to word pls help

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.

Thank you sir! #reallifesuperhero

Hello, I have two different accounts in MS Outlook 365 I want to mail merge from a word file to one of the accounts. However, I made that account a default still sending from the other account which I don’t want. Can someone please help me with this?

In Office 365 only works the first option. In older versions I used the DDE and was easier

its easier to use codes, i think

None of the methods worked for me.

too long music is not funny. Totally annoying. Regarding information too long of a talk. Please you know too much you are a good expositor but please pretty please make it shorter... it would save everyone a lot of time.... Too much talk man... OMG

how can we convert Date in to Text ? Example. 16/11/2022 Sixteenth November Two Thousand Twenty Two

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.