default format for Excel numbers

  • Thread starter Thread starter Chuck G
  • Start date Start date
C

Chuck G

Bringing up a new sheet and typin in the number 262 in any cell, gets entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it back
to normal?
 
Tools > Options > Edit > Clear the fixed decimal places checkbox

If this post helps click Yes
 
Hi,

In 2007 press Alt+1, choose Advanced, uncheck Automatically insert a decimal
point
 

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

Default number format in Excel 1
Excel number format 3
default format for Excel numbers 2
Number automatically divided by 100, why? 4
Can I sort and not lose reference to the cell? 3
Conditional formatting in Excel 2010 2
Number Format Problem 2
Entering 'GTi' but I get 'Gti' ! 2

Back
Top