Hi
When I import any number data it formats ok only if every cell in the column is a number, but if 1 or more is text, the whole column becomes text
How can I format it the same as source file which is formatted as number and any text in the column Doesnt affect it
Doesn't matter if it's dates integers, numbers 1.23, % or times 1:23 and both columns are formatted the same it happens
When I import any number data it formats ok only if every cell in the column is a number, but if 1 or more is text, the whole column becomes text
How can I format it the same as source file which is formatted as number and any text in the column Doesnt affect it
Doesn't matter if it's dates integers, numbers 1.23, % or times 1:23 and both columns are formatted the same it happens