Importar texto a Excel y conservar separador de decimales

%3CLINGO-SUB%20id%3D%22lingo-sub-1056527%22%20slang%3D%22es-ES%22%3EImport%20text%20into%20Excel%20and%20keep%20decimal%20separator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1056527%22%20slang%3D%22es-ES%22%3E%3CP%3EWhen%20importing%20text%20from%20Excel%20from%20a%20TXT%20file%2C%20which%20has%20column%20separator%20tab%20and%20decimal%20separator%20point%20(.)%20-such%20as%20Excel%20and%20Regional%20Settings-%20Excel%20does%20not%20recognize%20point%20as%20decimal%20separator%20and%20leaves%20it%20as%20an%20integer%20number.%20%3CBR%20%2F%3EWhat's%20the%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F160787i01CDA8DEAE3383B3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22.JPG%20points%22%20title%3D%22Puntos.JPG%22%20%2F%3E%3C%2FSPAN%3E%20you-%20the%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1056527%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EPreserve%20decimals%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EImport%20external%20data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETXT%20to%20XLSX%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Al importar texto desde Excel de un archivo TXT, que tiene separador de columnas la tabulacion y separador de decimales el punto (.) -tal como Excel y la Configuracion Regional- Excel no reconoce punto como separador de decimales y lo deja como numero entero.
Cual es el problema?

 

Gracias-Puntos.JPG el problema?

0 Replies