11-30-2021 07:00 AM
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
Solved! Go to Solution.
11-30-2021 07:30 AM
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...
11-30-2021 08:33 AM - edited 11-30-2021 08:35 AM
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.
11-30-2021 09:52 AM
Do a search and replace of m -> e-3 in excel 😄