Forum Discussion
Solved
[GELÖST] -- Dublikate in Telefonnummern suchen und löschen
Ich habe eine Spalte mit Telefonnummern, die ich gern auf Duplikate prüfen möchte. Ich habe bereits die Excel-Funktion "Duplikate entfernen" genutzt. Ich möchte dennoch prüfen ob auch alle Duplikat...
kkoperator The article in the link is a bit unclear. The Phone Number type appears when you select Special and then change the Language/location to e.g. English (US). Several other languages also show this option, but not all. Select "Phone Number" and then select Custom. Now you see the custom format for a US phone number, and create your own from it.
Note: These screenshots were taken on a Mac but it looks similar on the PC version.
kkoperator As I wrote earlier, you need to switch to English (USA) first. Then, back to Custom (Benutzerdefiniert). Now you need to edit the format so that it fits German phone numbers, which will then be available in the current workbook under Custom (at the bottom of the list).
Super, klappt! Danke