Format Mail Merge Numbers with Decimals and Commas

[@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 😁

[@elviarojas4848]

Thank you very much for you tutorial

[@ExcelInsights]

Glad it was helpful!

[@ozgurduran4699]

Exactly what I was looking for ...

[@lolas648]

That was excellent. Thank you so much. I needed to use that formula in 2 areas of my letter and it worked like a charm. You saved me from doing this manually to over 100 letters.

[@1krista1969]

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

[@NathanKruger1]

Thank you! You saved me!

[@ExcelInsights]

Glad it helped!

[@LouiseTaylor-zu3db]

excellent step by step - thank you!!!

[@TheresaGD]

thank you very much, you are a good teacher.

[@jedicahzhyrebuhong1908]

OMG! Problem solved!! :D maraming salamat po sir :)

[@jeanmondesir9094]

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

[@dorisyu-n2r]

Thanks you save my working life!

[@khamisahismail4182]

Hi, What is the syntax for proper case format?

[@kirachamberlain9163]

This is an excellent video! Thank you. What is the code to fix percentages?

[@ExcelInsights]

You can try #.00%

[@baltaza]

AWESOME EXPLANATION!!

[@ExcelInsights]

Glad you liked it

[@kathleenwatson2071]

Thanks much, this helped

[@ExcelInsights]

Glad it helped

[@emtiazansari4424]

Save my day, thanks a lot

[@salvadormorga2575]

Thank you so much sir!!

[@CatsOwnThis]

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

[@ExcelInsights]

Glad it helped!

[@kimberlyngo1200]

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

[@nativekesh]

Lifesaver--thanks!

[@sandeepaherath8568]

Thanks Buddy♥️

[@ExcelInsights]

No problem 👍

[@modupedisu7076]

Thank you so much

[@MdRokunuzzamanrbd]

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

[@Random13Guy]

A BIG THANKS!

[@jenns1465]

Waahhh! Thank you for this.😘

[@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?

[@AndreaSteele-b3v]

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.

[@sashikumar9587]

Thank you

[@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.

[@lullabyorangs9794]

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

[@andromeda6453]

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

[@ExcelInsights]

Try #,.#00

[@jonimaecapiniglara288]

SALAMAT!

[@ExcelInsights]

Walang anuman!

[@pankajgade4528]

What about indian lakh seperator .... 2,34,000/- it shows 234,000/- even I use \##,##,### Please help ??

[@ExcelInsights]

Try this ##\.##,

[@shwetamahindrakar7855]

Hi please help us Indian lakhs separtor i tried ur reply for 2,34,000 but no result

[@WandaFirle]

Perfect instructions! Thank you!

[@sivchhing1881]

Thank you so much

[@NaeemMiah-x9f]

A BIG THANKS!