| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
when I type numbers in a cell it changes it to a decimal point
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I type numbers in a cell it changes it to a decimal point
Turn off fixed decimal
Before XL 2007, Tools/Options/Edit - uncheck fixed decimal Don't know where it would be on XL 2007. "Ton" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I type numbers in a cell it changes it to a decimal point
This worked! Thanks very much, I have had this problem for over a year and couldn't figure out what was wrong. Again! Thanks! "Ton" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I type numbers in a cell it changes it to a decimal point
your welcome - thanks for the feedback
"Christopher819" wrote: This worked! Thanks very much, I have had this problem for over a year and couldn't figure out what was wrong. Again! Thanks! "Ton" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
when I type numbers in a cell it changes it to a decimal point
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 On Tue, 30 Sep 2008 18:39:06 -0700, Christopher819 wrote: This worked! Thanks very much, I have had this problem for over a year and couldn't figure out what was wrong. Again! Thanks! "Ton" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| aligning by decimal point - negative and positive numbers | Excel Discussion (Misc queries) | |||
| ALL NUMBERS I TYPE HAVE DECIMAL POINT | Excel Discussion (Misc queries) | |||
| Cut &paste clears numbers after the decimal point | Excel Worksheet Functions | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
![Ton[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
