format text field as number

[JitseSchaafsma]

I have a text field containing some numbers seperated by carriage returns (so they are displayed as a column).

Now my question is how can i format a text string to a number. For example

12356,00 should be Eurosign 12.356,00

So what i actually want is to have the number formating as standard in filemaker used on my text field.

Is this possible?

Thanks Jitse

[Wim Decorte]

Sure it is, but it will be a bit of a complex calculation. These links below are for custom functions in FM7 but the calculations that are in there might be a good start:

http://www.briandunning.com/filemaker-custom-functions/

http://www.clevelandconsulting.com/support/

HTH

Wim

[Lee Smith]

Hi Wim,

I'm I missing something here. How will he be able to see the calculations in a v7 file, I only see v5 mentioned?

Hi Jitse,

Use the TextToNum function and then format the number in the Layout mode.

HTH

Lee