format of a number

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

lulu50Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Pravin AsarConnect With a Mentor Principal Systems EngineerCommented:
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
 
lulu50Author Commented:
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
 
lulu50Author Commented:
Thank you for taking the time to help me.
0
 
Pravin AsarPrincipal Systems EngineerCommented:
Thanks for the points
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.