weird divide by 100 problem in blank sheet.

D

Doz

Hi all,

Hope someone can help me out here...

When I open Excel and start a new XLS document all goes as expected.

When I type in a number (any number) it gets divided by 100... !!

Eg.. type in 120 press enter... 1.20 is shown.

This is in a blank workbook.

Any ideas what is causing this ??

I've looked at "Style" and number format is set to General.
I've tried other number types in there too.. to no avail,.

Regards,

Doz
dcreber<at>camfordpress<dot>co<dot>uk
 
C

Chip Pearson

Doz,

You have the Fixed Decimal setting enabled. You should see the
'FIX' status indicator in the lower right corner of the screen. To
turn this off, go to the Tools menu, choose Options, then the Edit
tab. There, uncheck the "Fixed Decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weird divide by 100 prob in blank sheets. 2
Number automatically divided by 100, why? 4
Numbered list problem 6
Numbers divide by 10 in any cell... 6
Typed numbers are divided by 10 (Excel 2007) 2
Colouring Ranges & Leaving Cells Blank 1
Form design question. 0
Number Automatically divided by 100 and stored in cell 2

Top