Fixed exponent in scientific notation

**shg** · 11-28-2009, 12:52 AM

I don't know what the analog is in C++, and I can't tell you how to change the format string for Polish settings, sorry.

Perhaps someone else will pipe in.

**krusader23** · 11-28-2009, 05:34 PM

Hi,
I've found and answer.
You have to type in: 0,0### "e3"
The space character right before the first double quote means: "display the value as thousands (divide the value by 1000)" and the "e3" thing is just a double char string added at the end of the number.
The thing with the space character is that when you add this space character at the end of the formula (and only at the end of the formula) Excel will treat it as a conversion flag: "display as thousands". Double space = "display as millions" and so on.

**Richard Buttrey** · 11-28-2009, 07:31 PM

Hi,

To meet your original request that the numbers should display the same fixed exponent, then the numbers should look like the following

2.3455E+3
897.0-3

You can get these by formatting the numbers with

##0.###0E+0

You'll need to replace the "." ,which in my regional settings is the decimal point, with your local setting - presumably the ","

Rgds