Format Mail Merge Numbers with Decimals and Commas

When you use mail merge, it does not pick up the format of numbers in Excel. When you need to add the commas and decimals in the merge field in MS Word, you need to apply a field code or syntax that mail merge will recognize to render the number format correctly.

[@kimberlyngo1200]

Finally! Lifesaver!! Thank you, Sir! :>

[@WandaFirle]

Perfect instructions! Thank you!

[@TheresaGD]

thank you very much, you are a good teacher.

[@elviarojas4848]

Thank you very much for you tutorial

[@ExcelInsights]

Glad it was helpful!

[@NathanKruger1]

Thank you! You saved me!

[@ExcelInsights]

Glad it helped!

[@ozgurduran4699]

Exactly what I was looking for ...

[@1krista1969]

This video is a life saver!!! Thank you!!!

[@user-vs6yr7vn8h]

Thanks you save my working life!

[@Katie-dp3jl]

Thank you so much! I couldn't find this explanation anywhere else.

[@ExcelInsights]

Glad it helped!

[@KatieMcBryde]

Me too! I needed it again yesterday, and could not remember the code, so I had to come back to the video again 😁

[@jeanmondesir9094]

Thank you so much this worked perfectly in a crucial moment !!!

[@salvadormorga2575]

Thank you so much sir!!

[@baltaza]

AWESOME EXPLANATION!!

[@ExcelInsights]

Glad you liked it

[@emtiazansari4424]

Save my day, thanks a lot

[@kathleenwatson2071]

Thanks much, this helped

[@ExcelInsights]

Glad it helped

[@nativekesh]

Lifesaver--thanks!

[@Random13Guy]

A BIG THANKS!

[@modupedisu7076]

Thank you so much

[@CatsOwnThis]

so helpful! thanks! got the exact answers to my prob :)

[@ExcelInsights]

Glad it helped!

[@jenns1465]

Waahhh! Thank you for this.😘

[@jonimaecapiniglara288]

SALAMAT!

[@ExcelInsights]

Walang anuman!

[@sashikumar9587]

Thank you

[@sandeepaherath8568]

Thanks Buddy♥️

[@ExcelInsights]

No problem 👍

[@user-db2hx1qe9e]

can you use the \# when you are also using /b and /f? I have a mergefield that is formatted add a number and when I merge any field that has decimals i get a false number... 38.10 turns into 38.100000000000001 but i cant seem to add a \# because the field already uses \b and \f. Any help you may have would be greatly appreciated.

[@khamisahismail4182]

Hi, What is the syntax for proper case format?

[@MdRokunuzzamanrbd]

Hi, in excel cell blank or 0. Then i want to show -. Can you please help. I mean accounting format.

[@rakquino]

What if I want the results to show as percentage? Please help. Thanks!

[@ExcelInsights]

Word cannot perform calculations in this aspect so make sure that your Excel data is just waiting to be formatted (i.e. not in decimal or less than 1.) The format code is simple /# #%

[@ayamohammed2108]

can you get asolution for PHONE NUMBER problems in mail merg ?

[@ExcelInsights]

What format do you need?

[@lullabyorangs9794]

can you change ( , ) to (. ) please???

[@gregdubz3522]

How can I show results as 0.00 and 5,555.55?

[@ExcelInsights]

Hi, use #s for numbers and 0s for decimals: #,#.00 with comma and two decimal places.

[@andromeda6453]

I want the result : 15.000 not 15,000 how?

[@ExcelInsights]

Try #,.#00

[@LouiseTaylor-zu3db]

excellent step by step - thank you!!!

[@user-hf7nx5qy7w]

A BIG THANKS!