How numbers are displayed

ctomblin · May 9th, 2002, 08:50 AM

Excel has started dividing by 100 every number I input. So if I input 2000 I see 20 in the cell. It happens in every cell in every worksheet including new worksheets. If I type 2000.00 I see the correct view, eg 2000, otherwise it's wrong.

Von Pookie · May 9th, 2002, 08:58 AM

Sounds like you've got fixed decimals turned on.

Go to Tools|Option|Edit tab and see if the box next to fixed decimals is checked.

Corticus · May 9th, 2002, 09:00 AM

go to your Excel options, click on the edit tab, and deselect the "fixed decimal" option.

Corticus

ctomblin · May 9th, 2002, 09:04 AM

Thanks guys, that's done it.

ctomblin · May 9th, 2002, 09:04 AM

Thanks guys, that's done it.

May 9th, 2002, 08:58 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Sounds like you've got fixed decimals turned on. Go to Tools\|Option\|Edit tab and see if the box next to fixed decimals is checked. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

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

May 9th, 2002, 08:50 AM	#1
ctomblin New Member Join Date: Apr 2002 Location: Sheffield, England Posts: 49	Excel has started dividing by 100 every number I input. So if I input 2000 I see 20 in the cell. It happens in every cell in every worksheet including new worksheets. If I type 2000.00 I see the correct view, eg 2000, otherwise it's wrong.

May 9th, 2002, 09:00 AM	#3
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	go to your Excel options, click on the edit tab, and deselect the "fixed decimal" option. Corticus

May 9th, 2002, 09:04 AM	#4
ctomblin New Member Join Date: Apr 2002 Location: Sheffield, England Posts: 49	Thanks guys, that's done it.