Forum Discussion
Importing CSV with numbers as text - for bar codes
Hi, I occasionally export both contacts and products as CSV from my POS software to do bulk edits in Excel. They contain both phone numbers (beginning with "0") and bar codes (13 digit). I u...
lindswhitehead , you have few options.
First, open Data->Get Data->Query options and unselect default Type Detection
That works for current workbook only.
Second, if above option is ON, starting your query do not load it immediately, click on Transform
and in right pane delete automatically added Changed Type step
after that close Power Query editor selecting Keep changes.
Third, you may use old wizard enabling it in options
after that use it to load your CSV from Data->Get Data->Legacy Wizard
selecting Text for the column(s) on third step of the wizard
