Forum Discussion
Solved
Using Excel for simple tables
Hello, One use I put Excel to is as a space to create records. One bug (as a manner of speaking) that I have is that, when I enter a word that contains the at sign, Excel assumes it an email addres...
For individual cells: prefix the value with an apostrophe '. This tells Excel to treat the value as plain text.
For general use:
- Select File > Options.
- Select Proofing in the navigation pane on the left.
- Click 'AutoCorrect Options...'.
- Activate the 'AutoFormat As You Type' tab.
- Clear the check box 'Internet and network paths with hyperlinks'.
- Click OK.
For individual cells: prefix the value with an apostrophe '. This tells Excel to treat the value as plain text.
For general use:
- Select File > Options.
- Select Proofing in the navigation pane on the left.
- Click 'AutoCorrect Options...'.
- Activate the 'AutoFormat As You Type' tab.
- Clear the check box 'Internet and network paths with hyperlinks'.
- Click OK.
Many thanks Hans!