Same data -- different format

[Jeff_Lipton]

I have 3 rows, all in the format of N/NNNN (such as 3/2000).  Two rows are formatted correctly; the third is formatted as a Date, even if I specify that the Field Type is Text.

Any ideas why?

[Idrissshatila]

Hello @Jeff_Lipton ,

in power query  (transform data) they perform some data type changes automatically when data is load, so go check if there's a transformation step of data type that changed your values and remove it.

[Jeff_Lipton]

Thsanks for your reply.

In the Changed Type applied step, the values for TransformColumnTypes are {"135 Ratio 1", type text}, {"135 Ratio 2", type text}, {"135 Ratio 3", type text}, so all should display the same.