Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
When I type 10 in a cell I keep getting 0.1 instead. Any thoughts
Data in cell. When I type the number 10 in a cell 0.1 comes up instead.
After totalling Nos. 10, 20, 25, 30 & 15 total comes as 0.100 instead of 100; my formual is =sum(E5:E9). I am using EXcel 2003. I go into general and click on text so I could keep the numbers as stated. I still get it wrong |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
When I type 10 in a cell I keep getting 0.1 instead. Any thoughts
Tools/Options/Edit, uncheck the Fixed Decimal places checkbox.
In article , Enthusiastic new user wrote: Data in cell. When I type the number 10 in a cell 0.1 comes up instead. After totalling Nos. 10, 20, 25, 30 & 15 total comes as 0.100 instead of 100; my formual is =sum(E5:E9). I am using EXcel 2003. I go into general and click on text so I could keep the numbers as stated. I still get it wrong |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
When I type 10 in a cell I keep getting 0.1 instead. Any thoughts
Thank you very much for your expertise. Well done, it has worked. Much
appreciated "Enthusiastic new user" wrote: Data in cell. When I type the number 10 in a cell 0.1 comes up instead. After totalling Nos. 10, 20, 25, 30 & 15 total comes as 0.100 instead of 100; my formual is =sum(E5:E9). I am using EXcel 2003. I go into general and click on text so I could keep the numbers as stated. I still get it wrong |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format axis number - bug? - More thoughts - A RESULT! | Excel Discussion (Misc queries) | |||
Further If statement thoughts... | Excel Discussion (Misc queries) | |||
need to insert the symbol for pi--any thoughts? | Excel Worksheet Functions | |||
hyperlinks in a spreadsheet keep breaking - any thoughts ? | Excel Discussion (Misc queries) | |||
Any thoughts on repetetive row inserts and copying???? | Excel Discussion (Misc queries) |