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 address and automatically converts the font to Calibri and the size to 11.
Is there a property I can give the cells in the table such that when I format my content, Excel doesn't step in and automatically formats it according to its - I assume - default settings?
Many thanks!
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.
2 Replies
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!
