Number format is working good for me in English but in French I need to have spaces between thousands and commas instead of dots. The numberformat function does not have any French options. Is there a way for me to do this?

Well, this will work:


but this a PITA to reuse. Enter ColdFusion UDFs . . . .

Here is the function, save this as numberformat_french.cfm somewhere accessible to your application:


Then, code your CFM page like this:


And you should be set.

If you haven't used UDFs, this is a perfect example to use them. If you have to do this a lot, then put the include in your application.cfm folder or inside another include that is designed to be called on pages where this functionality is required.

Once the include is called all you have to do is wrap your number in the function format and be sure that is somewhere in a <cfoutput>.

Thats quick and dirty solution - hope that helps.

Wow thanks a lot! I appreciate your help. I'm integrating your script.

Hey no problem.

Let me know if you have any question implementing this. It should be pretty straight forward - put the include where ever you want to use the function, then use the function as many times as you like on that page.

What is nice about this, if you set you number to a different variable, you can still use it for calculations that your page might require, then when you are ready to display the value in your format, just throw it in this function and you're set.

Have fun - you're now using CF UDFs - you are getting sucked in, I can feel it . . . .


Yes, its that easy, stop trying to convince yourself that its can't be . . . . unlearn the ways of the dark side Luke!!!

Implemented successfully!

...but the dark side is so much more powerful!

lol - that is debatable, regardless, the dark side looses every time!


Good job, btw, on getting that code worked in.

Just realized something, by adding a space between thousands, if the number is in a cell it'll wrap. I changed the space to &nbsp;

Now it is perfect

nicely done

BTW, There is a CF function for this, but I had forgotten about it:
LSCurrencyFormat()

but I think this partly is based off of where the server is located.

I'm just pointing this out in case someone come along afterwards and mentions this function. You have a solution that works and is platform and location independant - so I think you are in good shape - obviously no need to investigate this unless you really want to.

I have used this function before to get the French month and day names. Worked pretty good. I'm not sure how it would work with numbers though...

Yeah. I've not had to use it, so I'm not sure what considerations there are for implementing it. In any case, you have your solution and it seems to fit well - thats count for a lot more.