2 Replies Latest reply on May 11, 2015 1:36 PM by Etienned´Ursel

    Excel import text not seen as text

    Etienned´Ursel

      Title

      Excel import text not seen as text

      Post

       

      Hello, 

      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.

      Regards

      Etienne

       

       

       

       

       

       

       

      FMforum.jpg