Excel Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-3361850%22%20slang%3D%22en-US%22%3EExcel%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3361850%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20enter%20in%200.75%20into%20a%20call%20and%20hit%20enter%2C%20its%20coming%20up%20as%200.75%20Dorcas%20Street.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20as%20to%20why%20this%20is%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20happening%20in%20any%20excel%20worksheet%20(and%20a%20blank%20worksheet)%20that%20I%20open.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3361850%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362068%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362068%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387741%22%20target%3D%22_blank%22%3E%40Irene101101%3C%2FA%3E%26nbsp%3B%20Does%20it%20happen%20to%20only%20one%20cell%3F%26nbsp%3BPerhaps%20a%20custom%20format.%20Set%20the%20format%20of%20the%20cell%20to%20General%20and%20re-enter%20the%20number.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362087%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3Eit%20happens%20in%20EVERY%20cell%20in%20the%20workbook.%26nbsp%3B%20Its%20like%20its%20a%20setting%20in%20Excel%20that's%20been%20changed%20-%20not%20specific%20to%20a%20particular%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3362138%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3362138%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387741%22%20target%3D%22_blank%22%3E%40Irene101101%3C%2FA%3E%26nbsp%3BCan't%20really%20tell%20without%20seeing%20the%20file(s).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3363120%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3363120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1387741%22%20target%3D%22_blank%22%3E%40Irene101101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Options.%3C%2FP%3E%0A%3CP%3ESelect%20Proofing.%3C%2FP%3E%0A%3CP%3EClick%20the%20AutoCorrect%20Options...%20button.%3C%2FP%3E%0A%3CP%3EType%200.75%20in%20the%20Replace%20box.%3C%2FP%3E%0A%3CP%3EDo%20you%20see%200.75%20Dorcas%20Street%20come%20up%20in%20the%20With%20box%3F%3C%2FP%3E%0A%3CP%3EIf%20so%2C%20click%20Delete%2C%20then%20click%20OK%20until%20you're%20back%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I enter in 0.75 into a call and hit enter, its coming up as 0.75 Dorcas Street.

 

Can anyone help me as to why this is happening?

 

Its happening in any excel worksheet (and a blank worksheet) that I open.

4 Replies

@Irene101101  Does it happen to only one cell? Perhaps a custom format. Set the format of the cell to General and re-enter the number.

@Riny_van_Eekelenit happens in EVERY cell in the workbook.  Its like its a setting in Excel that's been changed - not specific to a particular workbook.

@Irene101101 Can't really tell without seeing the file(s).

@Irene101101 

Select File > Options.

Select Proofing.

Click the AutoCorrect Options... button.

Type 0.75 in the Replace box.

Do you see 0.75 Dorcas Street come up in the With box?

If so, click Delete, then click OK until you're back in Excel.