Hi,
Is there a way to preserve numbers stored as text when using power query to rearrange data? I have some columns which are numbers stored as text and some of these have leading zeros which I need to preserve.
Any ideas?
Hi,
Is there a way to preserve numbers stored as text when using power query to rearrange data? I have some columns which are numbers stored as text and some of these have leading zeros which I need to preserve.
Any ideas?
Hi,
Is the source file xlsx?
In this case, open the PQ Editor and delete the Change Type step. After that, you can choose the format of each column
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks