7100_en-US

liliconcom

Formula : (1) to Numeric (2) get data more simple way<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Hi there~ 

(1) to Numeric

    I would like to change character value data to numeric value

    could you tell me the way? 

(2) Get data more simple way   (Difficult one)

    How can I get data with more simple formula?

I appricate ur help in advance.

Re: Formula : (1) to Numeric (2) get data more simple way

Hi James,

The Num() function will convert character strings to numeric values.

I don't think I can offer any advice on simplifying your formula.

-Jeff