Using Excel for simple tables

[guycruls]

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!

[#2 · Accepted solution]

@guycruls 

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.

[#3]

Many thanks Hans!