number format like %g from C

[GetHelp]

Hey folks,

there's this neat number format %g that you can use in C, C++ and so on for the function printf(). It's the shorter version of %e. It's the more compact version of %e or %f as insignificant zeros do not print, as defined in: "ANSI specification X3.159-1989: "Programming Language C," ANSI, 1430 Broadway, New York, NY 10018".

Is there a possibility to use this format in Excel without writing any VBA code?

Thanks
-GH

[teylyn]

No. Excel native functionality does not have that format. You define how many decimal points you want to show. Omitting insignificant zeros is not an option without using VBA.

[GetHelp]

Alright. That was quick and easy.

Thanks

[teylyn]

In der Kürze liegt die Würze!