Loading from excel, formatting is lost

[#1]

I am trying to load a column that has a format - (Hour format)

Excel displays it as normal integers,

1 to 500 hours

However, Qlikview reads it as the "value" format (back end format prior to the hour conversion)

For example:

Hours as displayed in excel	Data (values) read by Qlikview
28	1.166667
18	0.75
25	1.041667
25	1.041667
26	1.083333
24	1
23	0.958333
18	0.75
6	0.25
6	0.25
7	0.291667
5	0.208333

Is there anyway I can load what is being displayed?

I know this might be unclear, please paste the right column into excel and format cells as custom. Type .

Thanks in advance

[Michael_Tarallo]

Hi Cedric - just making sure - are you using QlikView and not Qlik Sense? If so I will move this over to the appropriate forum.

Mike

[#3]

I am using Qlikview, apologize for mixup.

[#4]

Actually, I was able to figure it out.

I multiplied the LOAD by 24.

Thank you. please remove/delete if necessary