View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default convert text to dollar

Just divide the number by 100, eg:

=A1/100

if your value is in A1.

Hope this helps.

Pete

julz wrote:
How do I convert a text number to dollar amount ?

Example :

711 to 7.11

17263 to 172.63