Exponential numeric format

Jim_Prentzas · February 11, 2026, 7:32pm

How can one format a numeric value using function FSTR$(Number,String) to show in exponential format for example: 0,00234 → 2,34E-03.

jbartlau · February 12, 2026, 6:32am

Hi Jim,

welcome to our community !

I’d rather use the CStr$ function for this purpose.

CStr$(0.00234, "%.2E" )

does the trick for me.

Jim_Prentzas · February 12, 2026, 10:41am

Hi Jochen,

Thanks for the quick reply. I used what you say and it does the trick, however it cannot take the proper decimal separator symbol that I am using for the number format like the FStr$ does. It only works with a point (.).

Jim

jbartlau · February 12, 2026, 10:55am

If you’re always using “,” instead of “.”, you could use

ReplaceStr$(CStr$(0.00234,"%.2E"),".",",")