Excel Number columns read as Text

Hello veronicaxge 

Ideally, if the source column formatting is number, Power BI/Query will pick accordingly. In case if it doesn't, then you can define it using Power Query Advanced Editor:

You might find a row in the Advanced Editor #" Changed Type" with the list of the column names along with the column properties {"Column Name" , type "Column properties"}

For setting the column properties as a decimal number you should use {"Clm Name", type number }

You have to do this setting once and going forward, Power BI will format the columns accordingly.

Br,

Vivek

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!