Consulting

Results 1 to 6 of 6

Thread: Hide Unnecessary Decimal Markers

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Mar 2016
    Posts
    3
    Location

    Hide Unnecessary Decimal Markers

    D3:E36 is Custom Formatted as ? ???.??? and contains simple multiplication formulas, eg: =(n*n)

    I want to hide decimal markers when whole numbers (without decimal places) are returned.

    Please see the yellow cells in the attached sample.

    Can someone please offer Macros that I can copy & paste?

    I am using Excel 2010.

    mgs
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •