Test for letters on clipboard data

Hi all,

How can i test my clipboard data (column of numbers) for letters among numbers?

i tried isnumeric but since i'm copying from excel the class of data is double true but i'm only interested in numbers...

i'm writing a wizard to help user create a text file with columns of numbers copied from excel where user pastes one column at a time by selecting the column in excel and then presses a button to paste it in to the text file, but i want to prevent user from copying letters inside the column that might be unseen. i was thinking in some kind of routine that checks the clipboard data for any letters and then return a warning or error message saying that data is invalid...but i'm running out of ideas...

Answer 1

[Walter Roberson]

xlsread() can return 3 outputs, one numeric, one text, and the other "raw".

[Nuno]

I don't want to use xlsread() because user doesn't actually creates a excel file he uses excel to gather all columns of data and then copy and paste each one at a time to the wizard by selecting it on excel spreadsheet and clicking on import button on the wizard to paste the data in to the text file...