Number() Function Details & Examples:

Number() function returns a number if the string can be converted to a number.
Otherwise, returns a Null

Examples:
Number(“15.25”) returns 15.25
Number(“5.073456E10”) returns 50734560000
Number(“953,486”) returns Null
Number(“75%”) returns Null
Number("$75.347") returns Null
Number("#876") returns Null
Number(“N”) returns Null
Number(“22253908723450973459872359073459073459073549734597”) returns 2.2253908723451e+49