cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Home

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
bcontrerash
bcontrerash
Occasional Visitor

‎12-09-2019 12:56 PM

‎12-09-2019 12:56 PM

Importar texto a Excel y conservar separador de decimales

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?

125 Views
0 Likes
0 Replies
Reply
Related Conversations
Preparing a stacked chart
 EuroSree in Excel on 02-17-2020
0 Replies
Please Help debug my matrix formula
 Katharina_Stemmer1989 in Excel on 02-17-2020
0 Replies
Linking external source (eg Share Price) to a cell
 Aitch1964 in Excel on 02-17-2020
0 Replies
Insert an image in Excel header
 mat74 in Excel on 02-17-2020
1 Replies
DAX Powerpivot - How to solve this problem in PowerPivot
 kayyeah11 in Excel on 02-16-2020
0 Replies
IF statements and conditional formatting
 clare1981 in Excel on 02-16-2020
1 Replies