Convert Engineering Notation into the SI prefix

[Acer]

I have a table of data with certain columns with capacitance values. The values are in string value, such as 100.00E-9. I want to display this data as 100.00nF instead.

There seems like there would be a real simple way of converting format into a number and use the format into string function to get nano, micro, or pico.

[tbob]

Convert the string into a number. In your numerical indicator, right click and select Format & Precision. Select SI Notation as the format. You will see values such as 50p for pico, 100n for nano, 3u for micro, and 40m for milli. You have to add the F for nF as a string located after the numerical indicator. So you would see 100.00n in the box and F after the box.

[Acer]

I need to clarify by saying I need to reprint the original string as a string again in the table. I need to go from "100.00E-9" to "100.00nF" so I can write this in a report in Word.

Thanks.

[GerdW]

Hello acer,

I think that's what you need...
Converts string (with number) and unit to string with SI unit. Perhaps some fine tuning is needed.

[Acer]

Thanks for both your help tbob and GerdW. I wasn't thinking clearly and didn't realize there was a format specifier for SI notation. The %p is exactly the thing I needed to reconvert number to string.

Thanks again very much,
Acer