# TEXT ## Definition(s) ### [[Nexus - Google Analytics Certificate Course|Google Analytics Certificate]] #### [[Spreadsheet]] >[! Definition] >This is a spreadsheet function that converts a number value, date, time into a specified text format. ## Examples ### Spreadsheet ```excel =TEXT(A1, "mmmm") ``` The above example will take the date value in cell A1, and convert it into the month full name. ## Related [[Function#Spreadsheet functions|Spreadsheet Function]] ## Resources ## Flashcards The below code are generated for use with [Spaced Repetition plugin](https://github.com/st3v3nmw/obsidian-spaced-repetition/) [docs](https://www.stephenmwangi.com/obsidian-spaced-repetition/) The {{TEXT}} function takes a number and outputs a text string in the given format. <!--SR:!2024-11-11,4,270-->