Is this what you want? I still don't really understand the subtleties of all the different scientific vs floating point formats and normally just play around until I get what I want.
I find going into the Advanced numeric formatting is a huge help as it basically tells you the exact formatting string to use. Especially useful for timestamps!