Forum Discussion
Daryl20
Apr 05, 2020Copper Contributor
how to set 2E02 into escel
Hi all, I am trying to put 2E02 into excel, however i am having trouble
Daryl20
Apr 05, 2020Copper Contributor
SergeiBaklan
Apr 05, 2020Diamond Contributor
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
- Daryl20Apr 05, 2020Copper Contributori am able to show 2e02 without the apostrpohe
- SergeiBaklanApr 05, 2020Diamond Contributor
You will see it without apostrophe. Alternatively Ctrl+1 on the cell and apply Text format to it, after that enter your text.