Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Microsoft Excel Help?
Everytime I use excel, when I use the letter "e" next to another number it multiplies it by 2.71 is there a way that I can just keep it the letter "e"
thanks
2 Answers
- dewcoonsLv 71 decade agoFavorite Answer
"E" refers to a special number that has the value 2.71. Like "Pi" refers to 3.14....
The easiest way to keep Excel from doing "math" on a cell that you want to stay letters and numbers is to format that cell as text. You can do that by beginning the entry in the cell with a ' (apostrophe). Just like beginning a cell with an = tells Excel to perform a math function on the cell, beginning it with an ' tells it to treat the entry as "text" and not convert it in any way.
