divide by 100
=A1/100
change to "Dollar" (text result, not numeric):
=DOLLAR(A1/100)
change to Fixed (text result):
=FIXED(A1,2)



"julz" wrote in message
...
How do I convert a text number to dollar amount ?

Example :

711 to 7.11

17263 to 172.63