Problème de correction des chiffres sur Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3116881%22%20slang%3D%22fr-FR%22%3EProblem%20correcting%20numbers%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3116881%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20a%20problem%20after%20converting%20a%20PDF%20file%20to%20Excel%2C%20I%20ended%20up%20with%20columns%20separated%20by%20periods%20instead%20of%20commas.%20And%20I%20can't%20use%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3116881%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3119904%22%20slang%3D%22en-US%22%3ERe%3A%20Probl%C3%A8me%20de%20correction%20des%20chiffres%20sur%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3119904%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1297221%22%20target%3D%22_blank%22%3E%40Max-Lumu%3C%2FA%3E%26nbsp%3BHow%20did%20you%20perform%20the%20conversion%3F%20And%20if%20the%20column%20separator%20consistently%20is%20a%20decimal%20point%2C%20try%20using%20Text-to-columns%2C%20delimited%20by%20a%20point.%3C%2FP%3E%3CP%3EOtherwise%2C%20perhaps%20Power%20query%20can%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour!

 

J'ai eu un problème à l'issue de la conversion d'un fichier PDF en Excel, je me suis retrouvé avec des colonnes séparées par des points à la place des virgules. Et je n'arrive pas à utiliser 

3 Replies

@Max-Lumu How did you perform the conversion? And if the column separator consistently is a decimal point, try using Text-to-columns, delimited by a point.

Otherwise, perhaps Power query can help.

@Riny_van_Eekelen 

 

HOW can i use power query please? i converted with PDF 2 GO on line

@Max-LumuNo guarantees that PQ will work, but in the link below you find some more information.

https://docs.microsoft.com/en-us/power-query/connectors/pdf 

From my own experience I can tell that the quality of the import highly depends on origin of the file.