Solved

format of a number

Posted on 2015-01-13
4
89 Views
Last Modified: 2015-01-13
Hi,

How can I change this number from

output: 
5,300,000 - 6,500,000
400,000 - 700,000
450,000 - 250,000
but 

this is how I want the output to be:

5.3M - 6.5M 
400K - 700K
450K - 250K




   <cfoutput>#numberformat(GrandFrom2020,'999,999,999,999,999,999,999')#</cfoutput> -
          <cfoutput>#numberformat(GrandTo2020,'999,999,999,999,999,999,999')#</cfoutput>  

Open in new window

0
Comment
Question by:lulu50
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
Pravin Asar earned 500 total points
ID: 40547188
Hope this works for you.

<cfset x=345000/>
<cfset y = 6500000/>
<cfscript>
      function MyFormatter(number) {
            formatDone = false;
            convertText= "K,M";
            convertFactore="1000,1000000";
            while (!formatDone) {
                  if (number/1000000 > 1) {
                        return "" & (number/1000000) & "M";
                  }
                  else if (number/1000 > 1) {
                        return "" & (number/1000) & "K";
                  }
                  else {
                        return number;
                  }
            }
      }

</cfscript>
<cfoutput>#myformatter(x)#</cfoutput>
<br/>

<cfoutput>#myformatter(y)#</cfoutput>
0
 

Author Comment

by:lulu50
ID: 40547204
Pravin

I don't know where to start to thank you

YOU ARE GREAT!!!

WOW What can I say!!!!!!

WOW AGAIN AND AGAIN

GOOD JOB!!!!!!
0
 

Author Closing Comment

by:lulu50
ID: 40547205
Thank you for taking the time to help me.
0
 
LVL 29

Expert Comment

by:Pravin Asar
ID: 40547298
Thanks for the points
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question