Show numeric value in currency format

[sbixsbix]

Hi,
I would like to represent some numeric fields in a format similar to the currency one of Excel.
I am using Alfresco Explorer interface.
I did some research with no appreciable reszults.
Have you some suggestion?

Thanks in advance

[sbixsbix]

I would like to show a numeric long value with thousands and decimal separators (i.e 1000000 = 1,000,000.00)

[rjohnson]

You will need to write a cusom form control that will use a Javascript library to format the number as you want. As you will need to input these numbers as well, you will need to add Javascript for "edit" mode that will strip out the commas before you post it back to the forms processor.

[sbixsbix]

Thanks rjhonson for the propmpt reply.
I am not that developper so I will need some more directions

[rjohnson]

If you are not a developer, then you have a problem. The simplest way to achieve what you need would be to take an existing control (number.ftl for example) and customise it with javascript to acheive what you need. Whilst not that difficult, it may not be that straightforward because of the need to strip out commas when editing (assuming your underlying property definition is numeric). I am afraid I cannot provide a step by step non developer guide because I would have to write it to do it.

There is a fair bit on the internet about custom forms controls, but it is all targetted at developers.