How to Use the Apostrophe in Excel


If you have a Microsoft Excel program loaded onto your computer, then you can use it to organize sets of data in a spreadsheet and to compute the data using Excel equations. Excel uses apostrophes in some of its functions as a way to identify numbers that should be recognized as text instead of numbers computable in equations.

  • Open a new Microsoft Excel worksheet.

  • Click on the empty box that looks like a search box. It is labeled "fx," which stands for function.

  • Type an apostrophe followed by your number. Hit Enter. You will notice that a tiny blue triangle appears in the upper left-hand corner of the cell. This is the way to tell the Excel program to store the number as text.

Related Searches


  • Photo Credit Burke/Triolo Productions/Brand X Pictures/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!