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)
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)