Format a number to any decimal places

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Format a number to any decimal places

    Hi! I'm having a small problem to format a number to some decimal places and
    I'd be glad if someone could please help me solve this issue. e.g. I have 2
    numbers number_1 = 100.0052 number_2 = 100.005165665 I need to format
    number_2 to the same number of decimal places as number_1, bearing in mind that
    number_1 could have 3,4,5 or any number of decimal places. Any idea how to do
    this please? This is what I have already done: 1. Get the position of the
    decimal place <cfset start = #findNoCase('.',number_1,1)#> 2. Get the number
    of decimal places in number_1 <cfset dp = #len(mid(number_1,start +
    1,len(number_1)))#> If I <cfouput>No. of decimal places = #dp#</cfoutput>, it
    returns 3, 4, 5 etc, depending on the no. of decimal places in number_1 Now
    how can i format number_2 to #dp# decimal places? Thanks and regards, Yogesh
    Mahadnac.

    YogeshM Guest

  2. Similar Questions and Discussions

    1. Max number of decimal places in cfprocparam?
      It appears that the maximum number of decimal places that cfprocparam will return is 12, using this syntax: <cfprocparam type="Out"...
    2. To 2 decimal places
      Folks, I know some of you here are extremely dynamic. I am working with a variable that is declared as a decimal. But I want to convert the...
    3. Limited the number of decimal places returned?
      I've moved on from functions for the time being, and was playing with do some maths and date/time manipulation. Lets say I wanted to show the...
    4. Decimal places!
      Hi fellow Director users!, I had a countdown timer (75 seconds) for a game, and I wanted to display the time taken to complete it, in a field. ...
    5. do not cut decimal places
      Hi, following problem (oracle8): I want to insert a value with precision (#.##) in a number(10,2) column. It works but the values which end with...
  3. #2

    Default Re: Format a number to any decimal places


    <cfouput>
    #NumberFormat (number_2, '0.#RepeatString ('0', dp)#')#
    </cfouput>
    MikerRoo Guest

  4. #3

    Default Re: Format a number to any decimal places

    An easier way to get dp:

    <cfset dp = Len(ListLast(number_1,"."))>
    OldCFer Guest

  5. #4

    Default Re: Format a number to any decimal places

    Thanks!
    YogeshM Guest

  6. #5

    Default Re: Format a number to any decimal places

    You're welcome.
    MikerRoo Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139