Scientific notation

[Guest]

How do I make it so when I concatenate a number in scientific notation, it
stays in scientific notation and does not place a decimal followed by the
exorbitant amount of 0s?

 

[Niek Otten]

=TEXT(A1,"0.00E+00")&"a"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I make it so when I concatenate a number in scientific notation, it
| stays in scientific notation and does not place a decimal followed by the
| exorbitant amount of 0s?

 

[MyVeryOwnSelf]

How do I make it so when I concatenate a number in scientific

notation, it stays in scientific notation and does not place a decimal
followed by the exorbitant amount of 0s?

I tried it but don't get exorbitant amount of 0s.

For example,
A1: 100000000000000000000
B1: ="DDD " & A1 &" mmm"
Gives this in B1 as I expected
DDD 1E+20 mmm

Likewise if A1 is a tiny fraction like 1E-20.

Maybe a place to look is:
Format > Cells > Number > Scientific > Decimal places

If that doesn't help, please give more details of the problem.