TEXT Function Dictionary
| Function Dictionary | Function Examples | Function Categories |
| TEXT | ||||||||||
| Original Number | Converted To Text | |||||||||
| 10 | 10.00 | =TEXT(C4,"0.00") | ||||||||
| 10 | £10.00 | =TEXT(C5,"£0.00") | ||||||||
| 10 | 10 | =TEXT(C6,"0") | ||||||||
| 10 | £10 | =TEXT(C7,"£0") | ||||||||
| 10.25 | 10.3 | =TEXT(C8,"0.0") | ||||||||
| 10.25 | £10.3 | =TEXT(C9,"£0.0") | ||||||||
| What Does It Do ? | ||||||||||
| This function converts a number to a piece of text. | ||||||||||
| The formatting for the text needs to be specified in the function. | ||||||||||
| Syntax | ||||||||||
| =TEXT(NumberToConvert,FormatForConversion) | ||||||||||
| Formatting | ||||||||||
| No special formatting is required. | ||||||||||