Numbers divided by 100

G

Guest

I just started a new project where I work on a computer with Excel 97.
When I enter a number into a cell, e.g. the number 8 it turns it into 0,08.
Of course I've checked the format of the cells and they are all set to
standard. If I change it to "numbers" (or what ever it's called in the
english version) it still divides everythings I put into the cells with 100.
Can anyone help me with where this setting can be changed?
Thanks!
 
B

Bob Phillips

Jane,

Go to Tools>Options and on the Edit tab, check if the 'Fixed Decimal' option
is checked. If so, uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Guest

Hi Bob,

Can I bother you one more time: My Excel is a Danish version, and I'm having
trouble finding the path you described. Where do I find "Tools"? Is it one of
the functions in the main menu or?
Thanks again!

"Bob Phillips" skrev:
 
G

Guest

Hi again,

I found it! And you were right, when I unclicked "fixed decimal" it worked
normally again. Thank you very much!


"Janepige" skrev:
 

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

Number automatically divided by 100, why? 4
numbers are being divided by 100 on leaving cell 4
Amount is divided by 100 2
Integers entered mysteriously divided by 100 3
Changing Text To Numbers ? 1
Excel number format 3
dividing a number up evenly into a year 3
COUNTIF Cells in Range? 4

Top