Finally! I had been searching forever and pretty much given up! No-one else had mentioned the "toggle field codes" step. And you explained everything so clearly. THANK YOU!!!!
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.
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.
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 /# #%
Finally! I had been searching forever and pretty much given up! No-one else had mentioned the "toggle field codes" step. And you explained everything so clearly. THANK YOU!!!!
Thank you so much! I couldn't find this explanation anywhere else.
Glad it helped!
Me too! I needed it again yesterday, and could not remember the code, so I had to come back to the video again 😁
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.
This video is a life saver!!! Thank you!!!
Exactly what I was looking for ...
Thank you! You saved me!
Glad it helped!
Finally! Lifesaver!! Thank you, Sir! :>
OMG! Problem solved!! :D maraming salamat po sir :)
Hi, What is the syntax for proper case format?
Hi, in excel cell blank or 0. Then i want to show -. Can you please help. I mean accounting format.
thank you very much, you are a good teacher.
Thanks you save my working life!
Thank you very much for you tutorial
Glad it was helpful!
Thank you so much this worked perfectly in a crucial moment !!!
excellent step by step - thank you!!!
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.
Save my day, thanks a lot
AWESOME EXPLANATION!!
Glad you liked it
Thanks much, this helped
Glad it helped
Lifesaver--thanks!
This is an excellent video! Thank you. What is the code to fix percentages?
You can try #.00%
so helpful! thanks! got the exact answers to my prob :)
Glad it helped!
Waahhh! Thank you for this.😘
Thank you so much sir!!
A BIG THANKS!
What if I want the results to show as percentage? Please help. Thanks!
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 /# #%
can you get asolution for PHONE NUMBER problems in mail merg ?
What format do you need?
Thank you so much
Thanks Buddy♥️
No problem 👍
How can I show results as 0.00 and 5,555.55?
Hi, use #s for numbers and 0s for decimals:
#,#.00 with comma and two decimal places.
Thank you
Hi please help us Indian lakhs separtor i tried ur reply for 2,34,000 but no result
What about indian lakh seperator .... 2,34,000/- it shows 234,000/- even I use \##,##,### Please help ??
Try this ##\.##,
can you change ( , ) to (. ) please???
SALAMAT!
Walang anuman!
I want the result : 15.000 not 15,000 how?
Try #,.#00
Perfect instructions! Thank you!
Thank you so much
A BIG THANKS!