export data from plot to excel appends "m" or "u" to data

[tony_wash_gx5]

Sometimes when I right click on plot and select export to Excel, the data in Excel has "m" or "u" appended, meaning 1.0E-3 or 1.0E-6. But I can't get Excel to recognize these as numbers.

Is there way to export in different format or to get Excel to recognize these numbers?

Thank you

[GerdW · Accepted solution]

Hi Tony,

---

@tony_wash_gx5 wrote:

Sometimes when I right click on plot and select export to Excel, the data in Excel has "m" or "u" appended, meaning 1.0E-3 or 1.0E-6. But I can't get Excel to recognize these as numbers.

---

Can you define "sometimes" more precisely? When exactly do you get those "u"/"m" chars?

Just a(n educated) guess: are you formatting the axis values to show SI units (%p)? If so: why do you wonder about getting such values when exporting to Excel?

---

@tony_wash_gx5 wrote:

Is there way to export in different format or to get Excel to recognize these numbers?

---

Sure: don't rely on built-in methods of the chart, but create your own routine to export data to a CSV file! It's quite easy: you need just one file function...

[wiebe@CARYA]

I guess you're formatting your strings with %p? Use %f, %g or %e (see the documentation).

%p formats numbers to strings with SI prefixes.

[Yamaeda]

Do a search and replace of m -> e-3 in excel 😄