Excel import text not seen as text
I am importing an Exel file whose first column is a textual numbering structure:
Two digits and a dot, any number of times. xx.xx.xx xx.xx.xx.xx . Although the formatting is "text" in Excel and the target field is a text xx.xx becomes xx,xx ( a comma instead of the dot ) when importing and there is only one dot. This just as if the text was converted to number and back to text during the import process. As I discovered in the forum I could use a Subsitute ( self: "," ; "." ) calculation but I would lite to understand what I am doing wrong.