Forum Discussion
[GELÖST] -- Dublikate in Telefonnummern suchen und löschen
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.
Furthermore, under the category "Custom", I am looking for the type "Phone number" in the format options...
Link: https://support.microsoft.com/en-us/office/display-numbers-as-phone-numbers-7feabe49-15b3-411c-a030-781b4f2c87dd#:~:text=On%20the%20Home%20tab%2C%20click%20the%20Dialog%20Box,Custom%20category%2C%20and%20look%20in%20the%20Type%20box.
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.
Riny_van_Eekelenas you can see, I do not have such a selection in Excel 365.
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