I'm importing a table from Excel and the value of some cells can be either text or numbers. In my program, if it's text, it will be treated differently than numbers. Is there a way I can see whether the value in my alpha series is a number or text?
Thanks!
Check if data is text
Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Check if data is text
Use the @val function to convert the text to a number. If it returns NA, you know it isn't a number.
Who is online
Users browsing this forum: No registered users and 2 guests
