Hi,

I want a string/Alpha to be a Format number Cell in Excel.
So I Need to tranform my Alpha value into a number.

My Source is a SQL, where my value is a A14V.

Thanks!!!

This message has been edited. Last edited by: FP Mod Chuck,

You could simply use EDIT(alphastring) if the string doesn't contain any alpha characters other than numerals.

TABLE FILE CAR
SUM COMPUTE ALPHA/A14V = '123456.65';
    COMPUTE NUMERIC/D12.2 = EDIT(ALPHA);
BY COUNTRY
END

I should add that a comma is not acceptable although a decimal point is OK.

If there are non-numerals then you will receive a value of zero.

T

when I Edit it, then I just get 0,00
Don't know why

What does a sample of your data look like? Does it contain commas because you are using continental numeric notation?

T

Ja, just recognized.

Solved ist. I changed my Format in my SQL, sothat it's already a number.


It's SOLVED

Probably the better way of acheiving it - it also pushes the validation to SQL as well!

T