1 | Result | Formula | |
|---|---|---|---|
2 | 7.30 | =TEXT(7.3, "0.00") | |
3 | 7.3 | =TEXT(7.3, "#.##") | |
4 | 7.3 | =TEXT(7.342, "0.0") | |
5 | 7.4 | =TEXT(7.352, "#.#") | |
6 | 14,000 | =TEXT(14000, "0,000") | |
7 | 14,000 | =TEXT(14000, "#,###") | |
8 | |||
9 | |||
10 | Result | Formula | |
11 | 01/09,2012 | =TEXT("01/09/2012", "mm/dd,yyyy") | |
12 | Jan 9 2012 | =TEXT("1/9/2012", "mmm d yyyy") | |
13 | J-09-12 | =TEXT("1/9/2012", "mmmmm-dd-yy") | |
14 | 15:09:25 | =TEXT("15:9:25", "HH:mm:ss") | |
15 | 03:09:25 | =TEXT("15:9:25", "hh:mm:ss") | |
16 | 4 PM | =TEXT("16:00", "h AM/PM") | |
17 | 6:10 AM | =TEXT("6:10", "h:mm A/P") | |
18 | January-09-2012, 01:15 PM | =TEXT("01/09/2012 1:15 PM", "mmmm-dd-yyyy, hh:mm A/P") | |
19 | |||
20 | |||
21 | Result | Formula | |
22 | 6.0% | =TEXT(0.06, "0.0%") | |
23 | 6% | =TEXT(0.06, "#.#%") | |
24 | 180% | =TEXT(1.8, "0%") | |
25 | $26.00 | =TEXT(26, "$0.00") | |
26 | $1,000.12 | =TEXT(1000.12, "$#,###.00") | |
27 | |||
28 | |||
29 | Result | Formula | |
30 | Google has 31,353 employees in 2011 | ="Google has " & TEXT(31353, "#,###") & " employees in 2011" | |
31 |