trouble reading the decimal after comma
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
trouble reading the decimal after comma
Hi, this may be foolish to ask however I have trouble importing data from excel to eviews. For example my data is 2,88419849281784 in excel but when I do copy paste it reads 2.00000000 in eviews. I tried to change the commas to dots in excel by find/replace (didn't work) and also by using file/options/advanced/use system separators/ decimal- dots (didn't work either). I also tried the paste special option in eviews still I have problem in getting the data right. What else can I do? thank you
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: trouble reading the decimal after comma
Could you post the Excel file? That sounds weird.
Re: trouble reading the decimal after comma
thanks a lot
- Attachments
-
- ikincideneme.wf1
- (10.85 KiB) Downloaded 211 times
-
- forum.xlsx
- (15.46 KiB) Downloaded 272 times
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: trouble reading the decimal after comma
How did you open it in EViews?
I just dragged that Excel file on to EViews, hit "Finish", and all the numbers worked just fine.
I just dragged that Excel file on to EViews, hit "Finish", and all the numbers worked just fine.
Who is online
Users browsing this forum: No registered users and 1 guest
