Welcome, Unregistered.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Prev Previous Post   Next Post Next
Old 01-Apr-2009, 17:54   #1
Cheezdoodles
+ 1
 
Join Date: May 2006
Posts: 3,924
Default Excel help

I got price data time series for stocks in excel.

Problem is that the data is downloaded from datastream, and this results in a desimal error (or rather, it forgets to put desimals into the number, the end result being that that instead of having a stock price of 12,12345 it shows as 12112345, meaning that the place where the , (or . depending on region) is supposed to be, is not there).

Is there an easy way to make excel put a , behind the first 2 numbers in each time series?

(cannot do it by hand, as its 2600+ observations for 20 different stocks)
__________________
"I'm going to get rich when i figure out how to stab people over the internet"
Cheezdoodles is offline   Reply With Quote

 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 22:26.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.