when I type numbers in a cell it changes it to a decimal point

T

Ton

This is happening to all my excel documents even those that were previously
created correctly, now when I modify them this happens even when I have
chosen the cell formatting of general numbers. It seems like my whole program
has had the formatting changed to reflect numbers as decimals. No matter what
my cell formatting is if I type the numbers 123456 it will change it to
1234.56?
 
J

JMB

Turn off fixed decimal

Before XL 2007,
Tools/Options/Edit - uncheck fixed decimal

Don't know where it would be on XL 2007.
 
C

Christopher819

This worked! Thanks very much, I have had this problem for over a year and
couldn't figure out what was wrong. Again! Thanks!
 
J

JMB

your welcome - thanks for the feedback

Christopher819 said:
This worked! Thanks very much, I have had this problem for over a year and
couldn't figure out what was wrong. Again! Thanks!
Click to expand...
 
G

Gord Dibben

You should try browsing through the Options now and again.

You may be surprised at what you find.

Like "fixed decimals"


Gord Dibben MS Excel MVP
 

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

Decimal 4
Typing an "E" within numbers changes cell 4
In Excel I type 24E1 in a cell it changes ... 6
Adding a decimal point to numbers 3
ALL NUMBERS I TYPE HAVE DECIMAL POINT 3
Formula to identify decimal versus whole numbers 11
How do I center numbers in a cell, but align by decimal? 2
Numbers view different when clicked on cell 3

Top