crosstable : prices are converted in date format?

[#1]

Hi,

I don't know why but when I make a crosstable it automatically recognizes my price field as a date

so instead of 150 I get a 40213 date value or something.

how can that be fixed?

thanks

[perumal_41]

Hi,

Upload your sample data excel for checking purpose

[#3]

i found it.

reformat the whole sheet to general, and fix the date with Date(Num#(date_field)) AS Date afterwards