PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WM20] display mask for currency
[WM20] display mask for currency
Iniciado por guest, 15,sep. 2015 18:27 - 6 respuestas
Publicado el 15,septiembre 2015 - 18:27
Hi,

i want to display e.g. 123456.90 as '123,456.90' (with the comma as the thousand separator)

but no matter what i tried ( using numtostring() or changing the display mask), it will still display as '123 456.90' ( with the space as the thousand separator)..

Anybody know of a solution ?

Regards,

PETER ZHOU
Publicado el 15,septiembre 2015 - 20:19
Hi Peter,

I was curious, so I just tested in windev 20, and simply used the wizard and checked a ew selectors... the result is this:
info)(NumToString(xNum, "6,2fS")
and on my computer it displays 123,456.90

Best regards
Publicado el 15,septiembre 2015 - 20:30
Hi Fabrice,

In Windev, no issue..but not WM20 on android ( it works on the simulator but not on the actual android device), it keep displaying as space for the thousand separator.

Regards,

PETER ZHOU
Publicado el 15,septiembre 2015 - 23:10
Hi Peter,

I've had problems with NumToString() when using a decimal file item as parameter.
When I use a intermediate currency or integer variable as parameter I do get the correct result.
Publicado el 17,septiembre 2015 - 10:01
Hi Stefan,

I have tried to assign to a currency data type and then use numtostring(cyCurrency,"12.2fS").

same result..i cannot get the comma as a thousand separator on the android phone/tablet.

Regards,

PETER ZHOU
Publicado el 17,septiembre 2015 - 11:23
Hi Peter,

Do you get the dot as decimal seperator ?

I use (in WinDev, not WDmobile) Numtostring(cyCurrency,"12,2fS") and get as result i.e. 123.456,10 (dot as thousand separator is standard in Dutch). May be you could also try "12,2fs" as mask ?
Miembro registrado
1 mensaje
Publicado el 07,febrero 2016 - 17:45
Hi everyone,
Have any of you found a solution for this issue?
I mean, perhaps a java native function to solve it.

Regards,

George

--
GeorgeA