Excel does not recognize equations formated as "Number" as numbers

Question

>I have this cell, S1 in an excel spreadsheet, written as ' 1+1 ' (quote marks added for clarity, not present in Excel)

>Using Ctrl+1 i set the cell to be a "Number"

> It works, no errors, shows "Number"

>Set next cell to be ' =0+S1 ' (quote marks added for clarity, not present in Excel)

>Returns " #VALUE! "

>Create function " =IF(ISNUMBER(S1);"true";"false") "

>It returns " false "

>check again
>S1 is still a "Number" format

A have a table representing mass, where "n" grams is represented as "n*10^-3" kilograms, and reformatting several hundred values would be a total pain!

is There some way for an equation to be represented as a number, and then evaluated in a separate cell?

Such as: " =0+S1 " returning "2"

The error happens at step " =0+"1+1" ", why does Excel add quote marks on it's own and how do i make it stop?

( just " =S1 " returns " 1+1 ")

I've tried searching online for some Excel function that can solve equations represented in a "Number" cell, but i haven't found anything

Normally " =1+1 " returns " 2 ", and it still does if i copy and paste the equation in the formula bar

P.S.

No pictures or screenshots added because every time i try to paste or upload an image file into this thing, it says "upload failed" for some reason, and dragging and dropping doesn't work either.

Thanks!

Answer 1

You could do this:

Select T1.

On the Formulas tab of the ribbon, click Define Name.

Enter Eval in the Name box, and the formula =EVALUATE(S1) in the Refers to box.

Click OK.

Enter the following formula in T1:

=0+Eval

Answer 2

I guess there really is no conveniet solution then, huh?

Answer 3

That is not going to work in any calcualation, 1+1 will be text, even though you can format as a number