how to set 2E02 into escel

Question

Hi all,&nbsp;I am trying to put 2E02 into excel, however i am having trouble&nbsp;

sergeibaklan · Answer

Daryl20&nbsp;
You try to enter number 200 in scientific format or text "2e02" and which kind of trouble do you have?

daryl20 · Answer

SergeiBaklan&nbsp;&nbsp;when i try to enter 2E02, it gives me 2.E+00.&nbsp;&nbsp;

sergeibaklan · Answer

Daryl20&nbsp;
That's a number 200 in scientific format - you may check in formula bar. That's correct result if you'd like to enter the number such way.
&nbsp;
If you mean text, add apostrophe in front as '2e02

daryl20 · Answer

i am able to show 2e02 without the apostrpohe

sergeibaklan · Answer

Daryl20&nbsp;
You will see it without apostrophe. Alternatively Ctrl+1 on the cell and apply Text format to it, after that enter your text.

Forum Discussion

how to set 2E02 into escel

5 Replies