locked
merge numbers not showing cents RRS feed

  • Question

  • I am merging dollar amounts that need to show to the penny. My "toggle code" is correct, except when the number ends in zero.

    \#"xxx,xxx.xx"} Then, it shows $500,000.2, leaving off the ending zero. The others work when they end in any other number.

    Monday, February 27, 2017 5:39 PM

All replies

  • The correct switch format is:

    \# $,0.00


    Cheers
    Paul Edstein
    [MS MVP - Word]

    Tuesday, February 28, 2017 3:24 AM
  • Hi Gina,

    Welcome to our forum.

    Have you tried using  "\#$#,##0.00" instead, which seems can work properly during my test:

    Hope this can be helpful.

    Best regards,
    Yuki Sun


    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, February 28, 2017 6:09 AM
  • Hi Gina,

    Tested with Paul's suggestion, that seems to be a more explicit solution:

    Please feel free to post back with any updates.

    Best regards,
    Yuki Sun


    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Tuesday, February 28, 2017 6:16 AM
  • Hi Gina,

    I am writing to see how everything is going with this issue. Is the problem resolved? If there is anything I can do for you, please feel free to let me know :)

    Best regards,
    Yuki Sun


    Please remember to mark the replies as answers if they helped.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, March 2, 2017 1:43 AM