I need help to format a cell in a report. The value comes from a linked excel sheet which in its turn gets its info from our business system. When exporting numbers from our business system it has the bad habit of formating numbers into a strange text like form. In excel there is a function "convert to number" that addresses this problem.
I need to format the specific cell in either in the report or query to a number. How can this be done?
Thanks in advance
/twallstr
I need to format the specific cell in either in the report or query to a number. How can this be done?
Thanks in advance
/twallstr