Help with charting exponential numbers

n.nx10^e is a text string to Excel.
n.nEe is a number (in standard computer exponential format).
I would replace "x10^" with "E" and then convert to number.

You haven't said where the numbers are coming from, so it is difficult to be more specific.
A) If they are hand entered numbers, simple use e or E on your keyboard instead of x10^ or *10^". Enter 1E6 for the first example, 3.4e6 for the second example, and so on. If the cell was formatted as "general" before the data entry, Excel will assume you intend to use a scientific format and "helpfully" apply a default "0.00E+0" format to the cell. If you don't like the scientific format, apply whatever format you like (just recognize that if you apply "General" again, the same thing will happen the next time you enter a value).
B) If these are text strings imported from a csv or other text file, use Find/Replace after importing the text. Find what: "x10^" Replace with: "E". If Excel does not automatically convert the result n.nEe text to a number, use any of these strategies for converting numbers stored as text to numbers: https://support.microsoft.com/en-us/...rs=en-us&ad=us Again, Excel may choose to "helpfully" format the resulting cell as scientific "0.00E+0".
C) If you decide a formula is better than a find replace command, use SUBSTITUTE() =VALUE(SUBSTITUTE(B2,"*10^","E"))

Something along those lines should work. Once you have the text converted to numbers, your chart should work just fine.

It worked exactly as you said and excel automatically changed it to scientific. Is there any way to have the x10 format in the chart axis though, possibly labels as well if I choose to have them? Thanks.
scientific.PNG

Is it possible? Yes, it is possible. The real question is -- is it worth the effort. Excel does not have anything like a mantissax10superscriptexponent number format, so it must be done as text with only part of the text superscripted. Manually it is relatively easy, but tedious. It can be automated with VBA (or your favorite macro language if you prefer a different language), but that requires an investment in time up front to program and debug the procedure. In my field, people don't usually make noise about the way Excel (and other programming languages) display exponential notation, so it is usually not worth the effort to pretty up the number format in this way. I also know that some journals and audiences can be rather insistent on using the standard scientific format.

Review this tutorial that shows how to do it: https://peltiertech.com/Excel/Charts...cNotation.html See what you decide to do.