How to read Random function Value from a Excel Column

I have a excel with a column(say Column D) containing the result of the below formula =RANDBETWEEN(44444,8888888).
Issue I am facing: When I am trying to use the read range activity on the excel and pull the data into a Datatable the coulmn(Coulm D) containing the random values are getting converted into a same value in all rows.
If I am using the read cell activity i am getting the correct values from Excel Column.Is there a solution available to overcome this issue?

Try selecting checking box “Preserve Format” in read range activity properties