Question posted 2012 · +5 upvotes
Try pasting =10**-2 into a cell in MS Excel. After pressing Enter, it turns it to =0.1. I can’t seem to find any documentation for **, but it appears to be a pretty odd exponentiation-like operator that cannot be used in an Excel formula (e.g., =A1**A2 is invalid`).
If this operator is not an exponentiation operator, what is it?
(N.B.: mathematically, 10-2 = 0.01, not 0.1)
Accepted answer +6 upvotes
** is the same as E
=4E3 == 4**3 == 4000
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.