TEXT function - Microsoft Support
WEBThe TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
Format text in cells - Microsoft Support
WEBFormatting text in cells includes things like making the text bold, changing the color or size of the text, and centering and wrapping text in a cell.
Change the format of a cell - Microsoft Support
WEBFormat cells by including predefined formatting styles, and things like borders and fill colors.
Quick Start: Format a worksheet - Microsoft Support
WEBFormat cells, numbers, text, and other data in Excel to improve readability. Learn how to apply borders, shading, text colors, and more.
Text functions (reference) - Microsoft Support
WEBConverts a number to text, using the $ (dollar) currency format. EXACT function. Checks to see if two text values are identical. FIND, FINDB functions. Finds one text value within another (case-sensitive) FIXED function. Formats a number as text with a fixed number of decimals. LEFT, LEFTB functions. Returns the leftmost characters from a text ...
TEXT (Funktion) - Microsoft-Support
WEBMit der TEXT-Funktion können Sie durch das Anwenden einer Formatierung mithilfe von Formatcodes die Anzeige von Zahlen ändern. Diese Funktion ist in solchen Fällen nützlich, in denen Sie Zahlen in einem besser lesbaren Format anzeigen oder diese mit Text oder Symbolen kombinieren möchten.
Format numbers as text - Microsoft Support
WEBIf you want Excel to treat certain types of numbers as text, you can use the text format instead of a number format. For example, If you are using credit card numbers, or other number codes that contain 16 digits or more, you must use a text format.
TEXT (Fungsi TEXT) - Dukungan Microsoft
WEBFungsi TEXT memungkinkan Anda untuk mengubah cara angka muncul dengan menerapkan pemformatan ke dalamnya dengan kode format. Hal ini bermanfaat ketika Anda ingin menampilkan angka dalam format yang lebih mudah dibaca, atau ketika ingin menggabungkan angka dengan teks atau simbol.
Ways to format a worksheet - Microsoft Support
WEBYou can manually format all of the data in a cell or range at the same time, but you can also use this method to format individual characters. For information on how to format data manually, see Format text in cells.
TEXTE (TEXTE, fonction) - Support Microsoft
WEBSélectionnez la colonne ou plage dans laquelle vous allez placer les valeurs, puis utilisez le raccourci Ctrl+1 pour ouvrir la boîte de dialogue Format de cellule. Dans l’onglet Nombre, sélectionnez Texte. Excel conservera désormais les 0 non significatifs.