locked
merge numbers not showing cents RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    The correct switch format is:

    \# $,0.00

    Cheers
    Paul Edstein
    [MS MVP - Word]

    Tuesday, February 28, 2017 3:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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