TEXT ()
This function returns a number in a given number format, as
text.
Best view in desktop mode.
|
A
|
B
|
C
|
D
|
|
|
1
|
Value
|
Result
|
||
|
2
|
3/9/2020
|
09 Mar 2020
|
=TEXT(A2,"DD MMM
YYYY")
|
|
|
3
|
3/9/2020
|
Monday, 09 March 2020
|
=TEXT(A3,"DDDD, DD
MMMM YYYY")
|
|
|
4
|
100
|
$100.00
|
=TEXT(A4,"$0.00")
|
|
|
5
|
25.63
|
26
|
=TEXT(A5,"0")
|
|
|
6
|
25.63
|
$26
|
=TEXT(A6,"$0")
|
|
|
7
|
25.63
|
$25.6
|
=TEXT(A7,"$0.0")
|
|
|
8
|
25.63
|
$25.63
|
=TEXT(A8,"$0.00")
|
|
|
9
|
50%
|
Total profit is 50%
|
="Total profit is
" & TEXT(A9,"0%")
|
|
|
10
|
3/9/2020
|
Register by 9-March-2020
|
="Register by
"& TEXT(A10,"D-MMMM-YYYY")
|
|
|
11
|
||||
The formatting for the text needs to be specified in the
function.
Syntax
=TEXT(NumberToConvert,
FormatForConversion)
Formatting
No special
formatting is needed.
No comments:
Post a Comment