Scribd
Upload
2 views1 page

Excel TEXT Function Formatting Guide

The document contains formulas and results from formatting values in a spreadsheet using different TEXT functions. The formulas section shows 12 TEXT functions used to format values from column A into various date, time, number, currency and percentage formats in column B. The results section displays the values from column A and the formatted values that result from applying the TEXT functions in column B.

Uploaded by

Mohan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

Excel TEXT Function Formatting Guide

The document contains formulas and results from formatting values in a spreadsheet using different TEXT functions. The formulas section shows 12 TEXT functions used to format values from column A into various date, time, number, currency and percentage formats in column B. The results section displays the values from column A and the formatted values that result from applying the TEXT functions in column B.

Uploaded by

Mohan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Formulas:

1
2
3
4
5
6
7
8
9
1
0
1
1
1
2

Results:

A
Value
07/07/2
015
42192
42192
18:00
0.75
36.3636
36
0.5555
567.9

B
Formatted Value
=TEXT(A2,
=TEXT(A3,
=TEXT(A4,
=TEXT(A5,
=TEXT(A6,

"dd/mm/yyyy")
"dd/mm/yyyy")
"mmm dd yyyy")
"hh:mm")
"hh:mm")

=TEXT(A7, "0.00")
=TEXT(A8, "0.0%")
=TEXT(A9, "$#,##0.00")
=TEXT(A10, "+ $#,##0.00;-5 $#,##0.00;$0.00")
=TEXT(A11, "+ $#,##0.00;5 $#,##0.00;$0.00")
=TEXT(A12, "+ $#,##0.00;0 $#,##0.00;$0.00")

A
1 Value
07/07/2
2
015
3
42192
4
42192
5
18:00
6
0.75
36.3636
7
36
8
0.5555
9
567.9
1
0
-5
1
1
5
1
2
0

B
Formatted
Value
07/07/2015
07/07/2015
Jul 07 2015
18:00
18:00
36.36
55.6%
$567.90
- $5.00
+ $5.00
$0.00

You might also like