DATI EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-2817775%22%20slang%3D%22en-US%22%3EDATI%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817775%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3ESalve%2C%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Eio%20ho%20copiato%20dei%20dati%20presi%20dal%20nostro%20gestionale%20interno%20su%20questo%20file%20Excel%20che%20allego.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3ENon%20riesco%20a%20fare%20la%20somma%20degli%20importi%20in%20quanto%20i%20dati%20Excel%20li%20legge%20come%20testo%20e%20hanno%20il%20simbolo%20'%E2%82%AC'.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3ECome%20faccio%20per%20trasformarli%20in%20numeri%20in%20modo%20cos%C3%AC%20da%20poter%20effettuare%20le%20varie%20operazioni%3F%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3EHo%20provato%20con%20la%20formula%20SOSTITUISCI(C3%3B%22%20%E2%82%AC%22%3B%22%22)%20ma%20non%20mi%20funziona...%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2817775%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2817895%22%20slang%3D%22en-US%22%3ERe%3A%20DATI%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1177160%22%20target%3D%22_blank%22%3E%40giorgiacandellori95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%C3%88%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Epossibile%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eaggiungere%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ela%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ecolonna%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ED%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ealla%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Etabella%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ee%3C%2FSPAN%3E%3CSPAN%3E%20u%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3Etilizzare%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ela%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Efunzione%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Edi%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eriempimento%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eflash%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Edi%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eexcel%3C%2FSPAN%3E%3CSPAN%3E.%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3ENella%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ecolonna%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ED%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Edigitare%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Emanualmente%3C%2FSPAN%3E%26nbsp%3B%22%3CSPAN%20class%3D%22%22%3E130%2C33%22%3C%2FSPAN%3E%26nbsp%3B%3CSPAN%20class%3D%22%22%3Enella%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ecella%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ED14%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ee%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ealcuni%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ealtri%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eesempi%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Edi%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ecome%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Ei%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Edati%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Edovrebbero%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eessere%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eformattati%3C%2FSPAN%3E%3CSPAN%3E.%20%3C%2FSPAN%3E%3CSPAN%20class%3D%22%22%3EPoi%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eapplicare%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3Eflashfill%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2817919%22%20slang%3D%22en-US%22%3ERe%3A%20DATI%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2817919%22%20slang%3D%22en-US%22%3ECos%C3%AC%20non%20va%20bene%20perch%C3%A9%20non%20mi%20prende%20i%20decimali%20dopo%20la%20virgola%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New Contributor

Salve,

io ho copiato dei dati presi dal nostro gestionale interno su questo file Excel che allego.

Non riesco a fare la somma degli importi in quanto i dati Excel li legge come testo e hanno il simbolo '€'.

Come faccio per trasformarli in numeri in modo così da poter effettuare le varie operazioni?

Ho provato con la formula SOSTITUISCI(C3;" €";"") ma non mi funziona...

4 Replies

@giorgiacandellori95 

È possibile aggiungere la colonna D alla tabella e utilizzare la funzione di riempimento flash di excel. Nella colonna D digitare manualmente "130,33" nella cella D14 e alcuni altri esempi di come i dati dovrebbero essere formattati. Poi applicare flashfill.

Così non va bene perché non mi prende i decimali dopo la virgola

@giorgiacandellori95 

È possibile accedere al campo D3:D5 Inserire manualmente i numeri nel formato desiderato: "100,00" , "200,00" e "250,00" e poi compilare flashfill. Non vengono visualizzate cifre decimali. Ora vai alla cella D11 e aggiungi manualmente ",50" In tal caso, i decimali dovrebbero essere completati in tutta la colonna. Se questo non funziona, aggiungere manualmente anche in D14 ",33". Spero che funzioni anche con lei.

Perfetto ora funziona...grazie grazie milleee