Function like "sprintf" for formatting numeric output

[avanderlaan]

I'm looking for a function like "sprintf" in C that creates string representations of numeric values according to a user-defined specification. For example

floating point: sprintf( string, "%1.5f", aFloat ) produces ".12345" where aFloat = 0.123451234512345...

scientific notation: sprintf(string, "%1.5e", aFloat ) produces 1.23451e-1

Thanx.

 

[zemp]

You can try the format function. similar to the one below.

Format(variable,"#,###,##0.00&quot

Examples,

Format(34,"#,###,##0.00&quot=34.00
Format(.12234,"#,###,##0.00&quot=0.12

Beware of rounding of decimal values. Thanks and Good Luck!

zemp

 

[avanderlaan]

Thank you, Zemp. I can use that as a starting point for representing scientific notation too (some of my exponents are in the e-14 range).