Excel 2002 general number format problem

Feb 27th, 2002, 09:20 PM

Hi,

I've installed Excel 2002, but every time I enter a number in a cell, it gets multiplied by 10. (meaning 7 automatically becomes 70, etc). This is really annoying and it only happens in Excel. Can anybody help me solve this?

Thanks!

anno · Feb 27th, 2002, 09:30 PM

long shot and can't think how it would have happened, but do you have fixed decimals (tools>options) set to -1?

Mark W. · Feb 28th, 2002, 07:50 AM

..and I bet that there's a FIX indicator on the right hand side of your status bar. Choose the Tools | Options... menu command, click on the Edit tab, and uncheck the "Fixed decimal" box.

Feb 28th, 2002, 10:42 AM

Thanks a lot! I did have the fix indicator. It works now fine.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 09:20 PM	#1
Guest Posts: n/a	Hi, I've installed Excel 2002, but every time I enter a number in a cell, it gets multiplied by 10. (meaning 7 automatically becomes 70, etc). This is really annoying and it only happens in Excel. Can anybody help me solve this? Thanks!

Feb 27th, 2002, 09:30 PM	#2
anno Board Regular Join Date: Feb 2002 Posts: 202	long shot and can't think how it would have happened, but do you have fixed decimals (tools>options) set to -1?

Feb 28th, 2002, 07:50 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	..and I bet that there's a FIX indicator on the right hand side of your status bar. Choose the Tools \| Options... menu command, click on the Edit tab, and uncheck the "Fixed decimal" box.

Feb 28th, 2002, 10:42 AM	#4
Guest Posts: n/a	Thanks a lot! I did have the fix indicator. It works now fine.