convert text to dollar

[Guest]

How do I convert a text number to dollar amount ?

Example :

711 to 7.11

17263 to 172.63

 

[Pete_UK]

Just divide the number by 100, eg:

=A1/100

if your value is in A1.

Hope this helps.

Pete

 

[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.

 

[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)

 

[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.

 

[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