Format issue on prices

[BenjaminCoe1440]

I'm trying to import the following forward prices from an xlsx file that I'm not allowed to edit

but when I import these into Qlik the values are being displayed as dates (tried as dimension and measures), see below. 

Can someone please explain why this is happening and how to convert the values from dates into numerical values?

Thanks

Ben

@vinieme12  any ideas??

[vinieme12 · Accepted solution]

In the data load editor wrap the fields in Num() function 

Example 

Tablename: 

Load

Elec

, Num([Jan 23]) as [Jan 23]

, Num([Feb 23]) as [Feb 23]

And so on....