hi,
i have a column of numbers some of which i want to display as powers e.g. 2^2 but i then want to add these numbers with others in an other column but excel doesnt seem to understand 2^2?
can anyone help me be able to keep the format as 2^2 but make excel see it as 4 in order to do calculations?
thanks J
Solved by M. F. in 28 mins