I have a large table where my numbers are in the scientific notation x10^ format (I used a formula to convert the Excel E scientific notation to the x10^), but I need the exponents to be superscripted. I know with formulas you cannot superscript just part of a cell, so I copied and pasted the formulas as values and now have a table of my scientific notation values (for ex. 1.6×10^-6 ), but the exponents still need to be superscripted.
I could go in manually and select the last two values to be superscript, but it is a large table and a task we complete often, so I am wondering if there is a way in VBA to only have the last 2 numbers in the cell to be superscripted. All the cells have a length of 9 (for ex. 1.6×10^-6), so 2 to the right are the numbers I would need to be superscripted. The range of the table that I need to complete this on is Range(“L5:T41”)
I have been trying to play around on VBA and tried to record a macro and see what the code generated says, but I cannot seem to figure out how to get the code to superscript for the whole range.
Thank you and please let me know if I was unclear.