Forum Discussion
Solved
Set column type while expanding from merged query
Hello, Here's a quick question: I am expanding a column after merging. In the source the column type is text and has values like: 0333, 0555, 0888 While expanding it expands like a whole number an...
I am working with Excel using Excel.Workbook(Web.Contents())
In matter of fact the type doesn't matter untill I don't lose the zeros. Like 0003 > 3, 0005 > 5.
MarcelBeug the change of the data type occurs while expanding and zeros are lost. I guess there's nothing to get them back.
It is very nice how you values remain their zeros while their type is a number.My temporary solution was to change the type to a number everywhere and duplicate the column with type text in the table that I visualize. Works pretty good but it would be better if that was not necessary.
Thank you both!
