| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Turns numbers into decimals.
Halfway through my final project Excel started acting weird on me. I've
restarted and re-opened Excel but it's still doing the same thing. If I type in a number ie: 1500000 it turns it into 15000 If I type in 1,500000 it keeps it proper and displays 1,500,000 Type in 123456789 it turns up as 1234567.89 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Turns numbers into decimals.
Sounds like you have fixed decimals on. Click TOOLS/OPTIONS and the click
the EDIT tab. Turn of the checkbox FIXED DECIMALS. -- Kevin Backmann "Jem" wrote: Halfway through my final project Excel started acting weird on me. I've restarted and re-opened Excel but it's still doing the same thing. If I type in a number ie: 1500000 it turns it into 15000 If I type in 1,500000 it keeps it proper and displays 1,500,000 Type in 123456789 it turns up as 1234567.89 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers & decimals | New Users to Excel | |||
| Sorting numbers with two decimals | Excel Worksheet Functions | |||
| scan a series of numbers and when it turns postive give me the yea | Excel Worksheet Functions | |||
| Sorting Decimals as Numbers | Excel Discussion (Misc queries) | |||
| How do Multiply whole numbers by decimals | Excel Worksheet Functions | |||
Linear Mode
