G
Guest
How do I convert a text number to dollar amount ?
Example :
711 to 7.11
17263 to 172.63
Example :
711 to 7.11
17263 to 172.63
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
Just divide the number by 100, eg:
=A1/100
if your value is in A1.
Hope this helps.
Pete
=A1/100
if your value is in A1.
Hope this helps.
Pete
G
Guest
Divide by 100
=Value(A1)/100 where A1=711 (or =Value(A1)*0.01)
are values TEXT or INTEGER? If the the latter, =A1*0.01 will be OK.
=Value(A1)/100 where A1=711 (or =Value(A1)*0.01)
are values TEXT or INTEGER? If the the latter, =A1*0.01 will be OK.
B
Bob Umlas
divide by 100
=A1/100
change to "Dollar" (text result, not numeric):
=DOLLAR(A1/100)
change to Fixed (text result):
=FIXED(A1,2)
=A1/100
change to "Dollar" (text result, not numeric):
=DOLLAR(A1/100)
change to Fixed (text result):
=FIXED(A1,2)
G
Guest
I don't understand what you mean by "dollar amount" but it looks like you can
just divide the number by 100. To do that for a range of cells follow this
procedure.
1. Enter 100 in a blank cell
2. Copy the cell
3. Select the range you want to divide by 100
4. Right Click and select "paste special"
5. Select "values" and "divide" and click ok.
just divide the number by 100. To do that for a range of cells follow this
procedure.
1. Enter 100 in a blank cell
2. Copy the cell
3. Select the range you want to divide by 100
4. Right Click and select "paste special"
5. Select "values" and "divide" and click ok.
G
Guest
Hi julz. In an empty cell type in 100. Copy the cell. Next, select all the
cells you want to convert and go to Edit - Paste Special and select Divide.
This will convert the text to a number and give you 2 decimal places. HTH
cells you want to convert and go to Edit - Paste Special and select Divide.
This will convert the text to a number and give you 2 decimal places. HTH