SOLVED

Using Excel for simple tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2351079%22%20slang%3D%22en-US%22%3EUsing%20Excel%20for%20simple%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2351079%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EOne%20use%20I%20put%20Excel%20to%20is%20as%20a%20space%20to%20create%20records.%3C%2FP%3E%3CP%3EOne%20bug%20(as%20a%20manner%20of%20speaking)%20that%20I%20have%20is%20that%2C%20when%20I%20enter%20a%20word%20that%20contains%20the%20at%20sign%2C%20Excel%20assumes%20it%20an%20email%20address%20and%20automatically%20converts%20the%20font%20to%20Calibri%20and%20the%20size%20to%2011.%3C%2FP%3E%3CP%3EIs%20there%20a%20property%20I%20can%20give%20the%20cells%20in%20the%20table%20such%20that%20when%20I%20format%20my%20content%2C%20Excel%20doesn't%20step%20in%20and%20automatically%20formats%20it%20according%20to%20its%20-%20I%20assume%20-%20default%20settings%3F%3C%2FP%3E%3CP%3EMany%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2351079%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2351120%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20for%20simple%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2351120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1009664%22%20target%3D%22_blank%22%3E%40guycruls%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20individual%20cells%3A%20prefix%20the%20value%20with%20an%20apostrophe%20'.%20This%20tells%20Excel%20to%20treat%20the%20value%20as%20plain%20text.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20general%20use%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20File%20%26gt%3B%20Options.%3C%2FLI%3E%0A%3CLI%3ESelect%20Proofing%20in%20the%20navigation%20pane%20on%20the%20left.%3C%2FLI%3E%0A%3CLI%3EClick%20'AutoCorrect%20Options...'.%3C%2FLI%3E%0A%3CLI%3EActivate%20the%20'AutoFormat%20As%20You%20Type'%20tab.%3C%2FLI%3E%0A%3CLI%3EClear%20the%20check%20box%20'Internet%20and%20network%20paths%20with%20hyperlinks'.%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2419946%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20for%20simple%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2419946%22%20slang%3D%22en-US%22%3EMany%20thanks%20Hans!%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
best response confirmed by guycruls (New Contributor)
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.
Many thanks Hans!