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

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"


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alan" wrote:

> 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,
Thank you. After some playing with the formats, I
discovered that what I really wanted was #,, "E+6"

Alan

Well, that's just a minor variation.

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

Glad I have helped you out.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Alan" wrote:

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