TONUMBER Question

[Mercator2]

Help:
Input number 8,80

I am reading this input in as a text and I want to output as a number. Currently this is being outputted as '880'.

TONUMBER(WEIGHT FIELD:FC_FROM1_C, "{#['.'##]}")

Can someone please help!
Thanks

 

[janhes]

If the comma represents a decimal point you could do
TONUMBER(substitute(WEIGHT FIELD:FC_FROM1_C,",","."), "{#['.'##]}")
There's probably a better way but can't think of it at the moment.

 

[Mercator2]

Thanks for your response. I gave the query incorrectly. It should be with a comma character:

TONUMBER(WEIGHT FIELD:FC_FROM1_C, "{#[','##]}")

This field must be written out with a comma,
e.g.: 8,80

Thanks And would appreciate more help!

 

[OllyC]

8,80 isn't a valid number - do you mean 8,800?

If you want 8,80 why not output it as text?

Cheers
Olly.