Função TRANSFORM() e Função VAL()

[valt...@valtecom.com.br]

Good afternoon friends,
I am encountering an anomaly with the TRANSFORM() Function and the VAL() Function.
When I transform a number using the TRANSFORM() function with @E it remains in the numeric form recognized in Brazil, for example, transforming the number 152456.78 I use TRANSFORM(152456.78,"@E 999,999.99") and the return will be 152,456.78, this is the format used in Brazil, but the number is transformed into a character and is stored in a LABEL and when I need to use it in some calculation I use the VAL() function, but the VAL() function recognizes the period (.) as a decimal place and not the comma (,) and everything to the right of the period is transformed into a decimal place.
In Brazil the decimal place is separated by a comma and the thousands by a period.
Have any of you guys faced this problem and can tell me how to solve it?
I'll wait.
Thank you.
Valteçom
Uberaba MG Brazil.

[Eduardo Rocha]

Hello! when I use @E I use val like this val(strtran(strtran(12.123,56,'.',''),',','.')) one strtran remove all dots and the other exchange comma for dot.

--
Visit our website on https://www.hmgextended.com/ or https://www.hmgextended.org/
---
You received this message because you are subscribed to the Google Groups "Harbour Minigui" group.
To unsubscribe from this group and stop receiving emails from it, send an email to minigui-foru...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/minigui-forum/1959ed4c-4091-4cda-b114-3e09b95859b0n%40googlegroups.com.