DOLLAR ()
This function converts a number into a piece of text
formatted as currency.
Best view in desktop mode.
|
A
|
B
|
C
|
D
|
|
|
1
|
Original Number
|
Converted To Text
|
||
|
2
|
10
|
$10.00
|
=DOLLAR(A2)
|
|
|
3
|
10
|
$10
|
=DOLLAR(A3,0)
|
|
|
4
|
10
|
$10.0
|
=DOLLAR(A4,1)
|
|
|
5
|
10
|
$10.00
|
=DOLLAR(A5,2)
|
|
|
6
|
10.25
|
$10.25
|
=DOLLAR(A6)
|
|
|
7
|
10.25
|
$10
|
=DOLLAR(A7,0)
|
|
|
8
|
10.25
|
$10.3
|
=DOLLAR(A8,1)
|
|
|
9
|
10.25
|
$10.25
|
=DOLLAR(A9,2)
|
|
|
10
|
10
|
$10
|
=DOLLAR(A10,0)
|
|
|
11
|
Syntax
=DOLLAR(Number, Decimal
Places)
Number: This is the number which needs to be
converted.
Decimal Places: This is the amount of decimal places
needed in the converted number.
Formatting
No special
formatting is needed.
The result will
be shown as a text entry.
No comments:
Post a Comment