Exporting numbers to Excel from a straight table AS NUMBERS not text

[Anonymous]

I'm getting numbers formatted as text by Excel when exporting from a straight table into Excel.

I bet there's a simple way to make Excel format them as numbers.

Who knows the answer?

John

[el_aprendiz111]

Hi

-Num(sum(Value), '#.##0')

-sum(value)*1

[Anonymous]

It works to use num().  Thanks.

Why is this necessary?

It is needed when I do something in my load script like

if(condition,1,0) as condition_count

Doesn't need to be used when just reading in a number from a table.

Can you explain?

John

[el_aprendiz111]

Hi,

exaple:

Script:

NUM(If(CONDICION>=1000,1,0)) AS FIELD,