Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : Lt - Lt / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 NUMBERVALUE Function Result TRUE Sheet Result Description 1 TRUE Simple NUMBERVALUE formulas with local references and values Function Expected Correct FunctionString Comment 123.456 123.456 TRUE =NUMBERVALUE(" 123.456 ",".",",") 123.456 123.456 TRUE =NUMBERVALUE(I3,"/") 123/456 2500.27 2500.27 TRUE =NUMBERVALUE("2.500,27",",",".") 0.35 0.35 TRUE =NUMBERVALUE("35%") 1.5 #VALUE! #VALUE! TRUE =NUMBERVALUE("3.5%") 0.035 0.035 TRUE =NUMBERVALUE("3.5%",".") Err:502 Err:502 TRUE =NUMBERVALUE(" 123.456 ",".",".") 0 0 TRUE =NUMBERVALUE(" ") Err:502 Err:502 TRUE =NUMBERVALUE(I10,"//") 123//22