[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: metastockdata to excel : formatproblem



PureBytes Links

Trading Reference Links


 
You can be the result is the same :
 
Excel makes : 249.375i just want a copy 
(so 24.9375)

Other Idea please ?
 
Thanks
 
Theo Lockefeer
 
 
 
 
<BLOCKQUOTE 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Herman van den 
  Bergen 
  To: <A title=metastock@xxxxxxxxxxxxx 
  href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx 
  Sent: Thursday, August 23, 2001 2:07 
  PM
  Subject: Re: metastockdata to excel : 
  formatproblem
  At 09:41 AM 8/23/01 +0200, you wrote: >>>>
  Hello friends,If i copy 
    the open price from the downloader data to excelexcel gives another 
    format :example : Open price in downloader : 
    24.9375Excel makes : 249.375i just want a copy (so 24.9375)<<<<I don't know 
  why this happens but if you want to copy price arrays to Excell you can select 
  the price chart or indicator, right click copy, and then paste it directly 
  into Excel.Good luck,Herman.>>>>
  How can i tell excel to give me : 24.9375 
    Change cell properties or ?? Thanks for 
    your help.Theo 
    Lockefeer<<<<