View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default coverting numbers format

Hi,

=A1/100

Mike

"jopat205" wrote:

information was imported into a program. The numbers need to be converted to
currency. I am forgetting the route to take on this. trying the usual format
command obviously doesnot work.
Example 15208825 should be 152088.25