Format Number

[fkeuroglian]

Hi, expert i recieved numbers in this strange format

how i can cast or convert to int??

attach excel with example  and qvw using this excel

Thank you a lot

Fernando

[MarcoWedel]

Hi,

works without any special effort if you adjust your DecimalSep:

SET DecimalSep='.';

hope this helps

regards

Marco

[#3]

Hey

I just loaded the data in a qv file and it seems to work. See attached.

[fkeuroglian]

Marco and Koushik it seems to be a format issue, i change what you tell me (set decimal) and work ok, but if i want that my thousand separator is the "." and my decimal separator will be ","???

i have problems changing this

Thank you a lot Marco and Koushik

Fernando

[#5]

Hey Fernando

I dont seem to understand your question. can you elaborate?

Regards

Koushik

[MarcoWedel · Accepted solution]

Hi,

try

Num(Num#(Numero, '' ,'.',',')) as Numero

regards

Marco

[ashfaq_haseeb]

Hi,

have a look at attached application.

Regards

ASHFAQ