Hei.. Her under are my data, which i import from a another table with the help of DATA> From Other Source> Excel Files*.
My problem is that all numeric values return as text how to convert these values to Number.. Pt. In original file these are in numeric format.
I use these codes in SQL for collecting data from all sheets.
SELECT all *from Ax
Union All
SELECT all *from MA
Union Al
SELECT all *from ut
Union all
Attached is a picture of the my output file.
I have opportunity to use =ABS() but it makes complications because they are more than 10 columns which i need to do as same.
Any help will be appreciable
Bookmarks