英文:
Power Query - Retain Number Formats
问题
我很新于使用 Power Query，我有点困惑是否可能在导入表格时保留数字格式。我有一个大约有 30 列的表格，我通过 Power Query 导入，然而，表格一旦导入到工作表后，所有的数字格式都会改变。是否有方法可以避免这种情况，保留源数字格式？
英文:
I am very new to using Power Query and I am sort of confused as to if its possible to retain number formats when importing a table. I have a table of around 30 columns that I am importing via Power Query, however, all the number formats change after the table is imported to the sheet. Is there a way to avoid this and retain the source number formats?
答案1
得分: 2
通常在导入表格后，Power Query 会自动生成一个“更改类型”步骤，其中它会将列类型设置为它认为你应该使用的类型。你可以点击右侧的X来删除该步骤，将格式重置为默认。
英文:
Usually after importing a table, powerquery auto generates a Change Type step where it sets the column types to what it thinks you should have. You can hit the X to remove that step, in the box off toward the right, resetting format to default
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论