Question re Custom Number Formats

[Alan]

I have columns of large numbers (like 254038016). Is there a way
to use custom formatting to make them always displayed in scientific
format but to a particular power (e.g., +E6)? Scientific format
appears to pick its own power but rather use the number of zeroes.

It is not clear to me how to do that. I do not want to change
the actual numbers in the cells.

Alan

 

[Wigi]

Alan,

You can put it in millions with for instance:

###,000,,

Make it like this and you also have the "scientific notation":

###,000,,"E+6"

 

[Alan]

Wigi,
Thank you. After some playing with the formats, I
discovered that what I really wanted was #,, "E+6"

Alan

 

[Wigi]

Well, that's just a minor variation.

It's the , 's that do the real work.

Glad I have helped you out.