Home

Changing the dot to a comma

%3CLINGO-SUB%20id%3D%22lingo-sub-360337%22%20slang%3D%22en-US%22%3EChanging%20the%20dot%20to%20a%20comma%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360337%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20want%20to%20change%20all%20the%20dots%20in%20this%20file%20to%20comma%2C%20is%20this%20possible%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360337%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360836%22%20slang%3D%22en-US%22%3ERe%3A%20Changing%20the%20dot%20to%20a%20comma%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360836%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20may%20Data-%26gt%3BText%20to%20Columns%20it%20using%20semicolon%20as%20separator%20and%20on%20the%20third%20step%20of%20the%20wizard%20for%20General%20in%20Advanced%20select%20proper%20decimal%20separator%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi! I want to change all the dots in this file to comma, is this possible? 

1 Reply
Highlighted

You may Data->Text to Columns it using semicolon as separator and on the third step of the wizard for General in Advanced select proper decimal separator