I'm assuming you copy and pasted the stock symbol.. you pasted a hyperlink. Both which you did request when you pasted a hyperlink (by default), albeit you may not have known that ahead of time.
When you enter values in Excel, sometimes it assumes you mean a certain thing. You entered data Excel thought was a date, so it was formatted as such. A couple of key points...
HTH
When you enter values in Excel, sometimes it assumes you mean a certain thing. You entered data Excel thought was a date, so it was formatted as such. A couple of key points...
- A *format* is not the *value*
- A date is tracked as a whole number, called a Serial Number
- One whole day is 1 whole number
- Partial days, i.e. 12 hours, count as 0.5
- Preceding a cell value with a single apostrophe will force the cell value as text
- The first single apostrophe will not show in the cell
- The first single apostrophe will show in the formula bar
- Pre-formatting cells prohibit most Excel assumptions
HTH
