I use the Get Worksheet as Collection MS Excel VBO to extract information from an Excel sheet to a BP collection.
But I have a problem with results from one column showing the wrong value, for example "1,0001E+12" rather than "1000005835442". The problem could be too narrow columns. But by some reason, the real value isn't showed when I expand the column. But the real value is "hidden behind" the cell, and appears in the "fx" textfield. See attached example of what I mean. But the VBO extract the "1,0001E+12" value, rather than "1000005835442" to the BP collection.
Do other experience the same problem, and knows how to solve this issue?
Thanks in advance.
