Results 1 to 9 of 9

Show as many Decimals as Needed

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    361

    Show as many Decimals as Needed

    Hi everyone

    I am looking for a way to display a minimum of two decimals, but where needed upto 5.

    So let's say with "general" formatting my numbers look like

    1005.15
    25.252
    35694.25698
    400
    36.147

    So the result should be

    1,005.15
    25.252
    35,694.25698
    400.00
    36.147

    Is there any way I could achieve this? Alternatively I am also happy with a VBA code... but I suspect this can be solved with formatting only.

    Thanks in advance

    FD
    Last edited by FallingDown; 06-17-2014 at 08:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to only show decimals if there are any
    By Myerse in forum Excel General
    Replies: 4
    Last Post: 04-20-2015, 03:58 PM
  2. Custom format to show decimals only when needed
    By Phalanxz in forum Excel General
    Replies: 8
    Last Post: 05-21-2014, 11:40 AM
  3. [SOLVED] 0;-0;;@ - format to show as two decimals places
    By johnmitch38 in forum Excel General
    Replies: 3
    Last Post: 09-05-2012, 09:34 AM
  4. Replies: 8
    Last Post: 08-15-2011, 10:12 AM
  5. No rounding needed with no decimals displayed
    By lordyoyo in forum Excel General
    Replies: 4
    Last Post: 12-19-2010, 06:58 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1