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?