Menu
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)
905
Microsoft Excel is preprogrammed to make it easier to enter dates. For example, 12/2 changes to 2-Dec. This is very frustrating when you enter something that you don't want changed to a date. Unfortunately there is no way to turn this off.
By placing an Apostrophe ( ' ) preceding the number, you will prevent Excel from reformatting the number and display the number exactly how you have it entered.
Find_text (required argument) – This is the character or sub-string we wish to find. Within_text (required argument) – The text string that we need to search. Start_num (optional argument) – Specifies the position in the within_text string, from which the search should begin.
Microsoft Excel might show ##### in cells when a column isn't wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
** is the same as E
=4E3 == 4**3 == 4000
118
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
