TEXT Function (Functions in Excel)
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. |
0 comments:
Post a Comment