How do I add numbers when I have a superscript on a few numbers?
 

I am doing a spreadsheet and want to indicate notatin with superscripts in a
few of the numbers. The numbers with the superscript are not being added.

How do I add numbers when I have a superscript on a few numbers?
 

Maybe something like this:

With
A1: (contains 5001, with the 1 as superscript, consequently the cell is text)
A2: 100

Then this formula adds the 500 and the 100
A3: =SUM(A1:A2)+SUMPRODUCT(ISTEXT(A1:A2)*INT(A1:A2/10))

In this case, A3 returns 600

Is that something you can work with
***********
Regards,
Ron

XL2002, WinXP


"Debbie" wrote:

I am doing a spreadsheet and want to indicate notatin with superscripts in a
few of the numbers. The numbers with the superscript are not being added.