View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stifler421 stifler421 is offline
external usenet poster
 
Posts: 1
Default converting commodity prices

I am attempting to convert commodity prices from a web query and cannot seem
to make it happen. The prices are in one column ( and example "339'4") so
properly converted it should read $3.395. I can do it use a text to columns,
but that is not automated and would prefer not to have to run the text to
columns everytime.