SOLVED

Disable all automatic conversion in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2367230%22%20slang%3D%22en-US%22%3ERe%3A%20Disable%20all%20automatic%20conversion%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367230%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057533%22%20target%3D%22_blank%22%3E%40aboroczky%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20that%20is%20not%20possible.%20Either%20format%20the%20cells%20as%20Text%20before%20entering%20data%2C%20or%20prefix%20the%20values%20with%20an%20apostrophe.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2367003%22%20slang%3D%22en-US%22%3EDisable%20all%20automatic%20conversion%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367003%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20disable%20all%20the%20automatic%20conversions%20in%20Excel.%3C%2FP%3E%3CP%3EWhat%20I%20mean%20is%20that%20if%20I%20type%20in%20something%20I%20would%20like%20that%20it%20would%20look%20exactly%20how%20I%20typed%20it.%3C%2FP%3E%3CP%3EExamples%3A%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EI%20type%20this%3A%2010001%20123%20and%20this%20is%20what%20I%20get%3A%2010001123.%26nbsp%3B%3C%2FLI%3E%3CLI%3EI%20type%20this%3A%205-5%20and%20I%20get%20this%3A%2005-May%3C%2FLI%3E%3CLI%3EI%20type%2012000929837%20723200000000%20and%20I%20get%3A%26nbsp%3B1%2C20009298377232E%2B22%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20understand%20that%20I%20can%20place%20the%20apostrophe%26nbsp%3Bin%20the%20beginning%20of%20each%20value%20but%20I%20would%20be%20much%20happier%20if%20I%20would%20need%20to%20place%20that%20apostrophe%20in%20case%20I%20want%20that%20Excel%20would%20convert%20my%20number%20or%20my%20text.%3CBR%20%2F%3ESo%20my%20question%20is%20that%20is%20there%20any%20ways%20I%20could%20disable%20this%20conversion%20feature%20for%20the%20whole%20application%20permanently%20and%20not%20only%20for%20certain%20cells%20for%20certain%20work%20sessions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20all%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2367003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello Everyone!

I would like to disable all the automatic conversions in Excel.

What I mean is that if I type in something I would like that it would look exactly how I typed it.

Examples: 

  • I type this: 10001 123 and this is what I get: 10001123. 
  • I type this: 5-5 and I get this: 05-May
  • I type 12000929837 723200000000 and I get: 1,20009298377232E+22

I understand that I can place the apostrophe in the beginning of each value but I would be much happier if I would need to place that apostrophe in case I want that Excel would convert my number or my text.
So my question is that is there any ways I could disable this conversion feature for the whole application permanently and not only for certain cells for certain work sessions?

 

Thank you for all the help.

2 Replies
best response confirmed by aboroczky (New Contributor)
Solution

@aboroczky 

Nope, that is not possible. Either format the cells as Text before entering data, or prefix the values with an apostrophe.

Hi @Hans Vogelaar!

 

Thank you for prompt reply.

It is a sad day for those who wanted to like Excel but due to its stubborn behavior cannot.