Les 12 options de formatage numérique d'Excel et leur impact sur vos données"

Please provide me with the English text you would like me to translate into German. I'm ready to translate technical documentation from English to German. Here is a translation of the provided text: ## Number Formatting in Excel Number formatting in Excel determines how numbers and formulas are displayed in cells. It offers various options to present numerical data in a clear and readable manner. ### General The "General" format displays exactly what you enter into a cell, whether it's a number or a formula. This number format is ideal when you use very long numbers (e.g., credit card numbers or phone numbers) as it prevents Excel from rounding them or converting them to exponents. If you later decide to use the values in text-formatted cells for calculations, you need to convert them to formats like "Number" or "General". To do this, select the corresponding cells, press Ctrl+1 (or Cmd+1 on Mac), and choose the appropriate number format. ### Special The "Special" number format allows you to add unique numbers like phone numbers, social security numbers, and postal codes with predefined structures. This number format is limited to individuals entering data for a selected group of nations. For example, after pressing Ctrl+1 and selecting "Special" in the left menu, choosing "English (United States)" in the "Region" dropdown will display various available number formats for that country. Conversely, selecting "English (United Kingdom)" reveals that Excel doesn't offer specific number formats for this region. If a specific number format isn't supported for your region, use the "Custom" number format instead (see below). ### Custom The "Custom" number format provides a list of codes that you can either use or modify to create a unique number format. For example, let's say I want to add the letter "H" to a list of numbers in a spreadsheet. To do this, I would select all cells containing the numbers I want to modify and press Ctrl+1 to open the "Format Cells" dialog box. Then, I would click on "Custom" in the left menu. Next, I choose the custom number type "0" and type "H" after the "0" before clicking "OK". Now, all my numbers will be followed by the letter "H". If a cell displays a series of hashtags (#####) instead of the entered value, it's likely because the column width is too narrow to display the content fully or because the applied number format doesn't match the entered data type. To resolve this issue, try widening the column first. If that doesn't work, change the cell's number format to match the type of data contained within.