My excel2000 divide numbers per 10 why?

G

Guest

In every old or new sheet and cell with general or number format when i type
a number, excel divide it per 10. For example when i type 80 after enter, i
see 8 in that cell.
 
B

Bernard Liengme

Use Tools | Options; open the Edit tab; uncheck the box called Fixed
Decimal....

best wishes
 
J

Jerry W. Lewis

Tools|Options and look on the Edit tab. Uncheck the fourth item down
(Fixed decimal Places)

Jerry
 

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

Custom Format to divide by 10 2
numeric entered automatically divided 100! 1
Finding an average of a list that could have 0 to 10 numbers in it 3
Excel question 3
Formula needed for dividing hours by numbers 4
Automatic divided by 100000 2
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
divide all numbers in range by a fixed number 2

Top