Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I am new to QV and have been struggling for a long time with this problem. I have en Excel spreadsheet both with numeric and text values related to costs e.g $12.000, $12 mil, 'Undefined', 'Unknown' and so on. What I am trying to do is to load all this information in the same dimension, but loading the numbers as Money and the Strings as text.
What I tried to do was to apply the Money() function to the whole column, but this ends up in a lot of blank spaces in the list box. I checked with the Text() function and I get all the values, but I need the numbers to be numbers.
Hope someone can help me in this one,
William
Can you post an excel document with those 'numbers'?