For some reason, in my data load, long numbers (15 characters) are interpreted as text. I used following formula to convert all values from this field to numbers:
NUM# (FIELD, '#.#' , '' , '.' ) as FIELD
It is not giving the result I want, as long numbers are still formatted as text. I see it from formatting in pivot table (long numbers are aligned to the left as text, while shorter numbers are aligned to the right) and also when I am exporting the data to excel (long numbers are formatted as text).
Reason why I want to format them as numbers, is because I need to link values from another table based on these numbers.
I am loading in data from live database. Column, which is causing me problems, contains unique identification numbers. There are two types of identification numbers in this column: 1) short, less then 10 characters 2) long, 15 characters.
When I load this column in, without doing any adjustments with formulas, then short numbers are displayed as numbers (aligned to right) and long numbers are stored as text (aligned to left).
I have tried suggested tips, but those haven't solved the problem.
Can anyone suggest a way, how to convert all identification numbers to numbers instead of text?
