how to set 2E02 into escel

[Daryl20]

Hi all,

I am trying to put 2E02 into excel, however i am having trouble 

[#2]

@Daryl20 

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

[#3]

@Sergei Baklan 

when i try to enter 2E02, it gives me 2.E+00.

[#4]

@Daryl20 

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.

If you mean text, add apostrophe in front as '2e02

[#5]

i am able to show 2e02 without the apostrpohe

[#6]

@Daryl20 

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